On Thu, Apr 2, 2009 at 9:46 AM, Nico Tromp <[email protected]> wrote: > Actually we use '00000000' for web_start and '99999999' for web_end.
Sounds fine, and again, nice solution :-)) > > 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 > > ******************************************** 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
