Actually we use '00000000' for web_start and '99999999' for web_end. On Thu, Apr 2, 2009 at 9:15 AM, Ard Schrijvers <[email protected]>wrote:
> On Thu, Apr 2, 2009 at 9:04 AM, Nico Tromp <[email protected]> wrote: > > Another possibility is changing the extractor in such a way that the > > property always will have a value. > > > > like: substring(concat([xpathexpression],'00000000'),1,8) > > > > This ensures that the value will be filled with eight zero's when the > value > > in the XML file is empty. > > Now the property web_start will either have the value 00000000 or the > actual > > value from the XML file. Now your DASL queries will become a lot smaller > > (and hopefully faster) because the whole part for checking on the empty > > value can be removed. > > Most likely Nick would need something like '30000000' instead of > '00000000' to ensure that an empty value would qualify d:gte. > > For the rest I really like this solution, great idea Nico! > > Ard > > > > > <d:gte> > > <d:prop> > > <h:web_end /> > > </d:prop> > > <d:literal>20090401</d:literal> > > </d:gte> > > > > > > > > Cheers > > > > Nico Tromp > > > > > > > > On Wed, Apr 1, 2009 at 2:04 PM, Ard Schrijvers < > [email protected]>wrote: > > > >> On Wed, Apr 1, 2009 at 12:56 PM, Jasha Joachimsthal > >> <[email protected]> wrote: > >> > Hi Nick, > >> > > >> > 2009/4/1 Nick Stolwijk <[email protected]> > >> >> <d:or> > >> >> <d:gte> > >> >> <d:prop> > >> >> <h:web_end /> > >> >> </d:prop> > >> >> <d:literal>20090401</d:literal> > >> >> </d:gte> > >> >> <d:eq> > >> >> <d:prop> > >> >> <h:web_end /> > >> >> </d:prop> > >> >> <d:literal /> > >> >> </d:eq> > >> >> </d:or> > >> >> To retrieve documents which have an enddate after today or an empty > >> >> enddate, I retrieve no documents. > >> >> > >> >> This started to happen after a reload of our database yesterday. > After > >> >> the reload we have removed the index and let it rebuild. Are there > any > >> >> other things we have overseen? How can this happen? > >> >> > >> > > >> > > >> > It's not possible to search for empty values. > >> > >> Exactly, and I doubt how it could have ever worked...? If you want to > >> search for empty values, we normally extract a different property, for > >> example web_end_length containing the string length of the property. > >> <d:literal >0</d:literal> would then result in the results with no > >> web_end property > >> > >> Ard > >> > >> > If you use Hippo Repository 1.2.16 there is a bug in the d:or in some > >> cases, > >> > see [1]. This has been fixed in Hippo Repository 1.2.17. > >> > > >> > [1] http://issues.onehippo.org/browse/HREP-278 > >> > -- > >> > Jasha Joachimsthal > >> > > >> ******************************************** > >> Hippocms-dev: Hippo CMS development public mailinglist > >> > >> Searchable archives can be found at: > >> MarkMail: http://hippocms-dev.markmail.org > >> Nabble: http://www.nabble.com/Hippo-CMS-f26633.html > >> > >> > > ******************************************** > > Hippocms-dev: Hippo CMS development public mailinglist > > > > Searchable archives can be found at: > > MarkMail: http://hippocms-dev.markmail.org > > Nabble: http://www.nabble.com/Hippo-CMS-f26633.html > > > > > ******************************************** > Hippocms-dev: Hippo CMS development public mailinglist > > Searchable archives can be found at: > MarkMail: http://hippocms-dev.markmail.org > Nabble: http://www.nabble.com/Hippo-CMS-f26633.html > > ******************************************** Hippocms-dev: Hippo CMS development public mailinglist Searchable archives can be found at: MarkMail: http://hippocms-dev.markmail.org Nabble: http://www.nabble.com/Hippo-CMS-f26633.html
