Hello, Wasn't this your format: ' value="20081014" ' ??
In that case, just as Jasha pointed out, just remove the type='date'. Lucene always does a lexical ordering, which for the format yyyyMMdd also happens to be correct for dates. Ard > > Hello, > > I tried with the following format yyyy-MM-dd'T'HH:mm:ss'Z' > but it did not work. > > I found something on the hippo documentation site which says > 'date':The property will be parsed as a date, works with the > standard DAV getlastmodified and creationdate properties. For > the hippo types, this shouldn't be possible since the format > is already string friendly. > > http://www.hippocms.org/display/CMS/06.+Using+DASL+Queries#06. > UsingDASLQueri > es-SlideNamespaceConfiguration > > What does that mean ? > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Jasha Joachimsthal > Sent: Friday, October 17, 2008 3:03 AM > To: Hippo CMS development public mailinglist > Subject: RE: [HippoCMS-dev] Issue with date sorting using DASL query > > Hi Arun, > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Arun > > Wagle > > Sent: donderdag 16 oktober 2008 21:48 > > To: [EMAIL PROTECTED]; [email protected] > > Subject: [HippoCMS-dev] Issue with date sorting using DASL query > > > We are trying to make a DASL query to get the data sorted by user > > defined date field. > > > > The sorting does not work. > > > > > > > > When I sort using the DAV properties like creationDate, > > modificationDate, the sorting works perfectly fine. > > > > Date stored in the metadata file > > > > <property name="date" namespace="http://hippo.nl/cms/1.0"; > > value="20081014" > > type="date" protected="false"> > <snip /> > > dasl-indexer.xml file > > > > <property namespace="http://hippo.nl/cms/1.0"; name="date" > > type="date" /> > > > > > > > > Let me know if you need more details. > > > > A quick reply is really appreciated. > > yyyyMMdd is not a supported date format for our Lucene index. > The following formats are supported for date: > EEE, dd MMM yyyy HH:mm:ss zzz > EEE MMM dd HH:mm:ss zzz yyyy > EEEEEE, dd-MMM-yy HH:mm:ss zzz > EEE MMMM d HH:mm:ss yyyy > yyyy-MM-dd'T'HH:mm:ss'Z' > > If you want to continue using yyyyMMdd, don't index the field > as date but as a normal string (i.e. remove the special > indexer configuration for this field). > > > Jasha Joachimsthal > > [EMAIL PROTECTED] - [EMAIL PROTECTED] > > www.onehippo.com > Amsterdam - Hippo B.V. Oosteinde 11 1017 WT Amsterdam > +31(0)20-5224466 San Francisco - Hippo USA Inc. 101 H Street, > suite Q Petaluma CA > 94952-3329 +1 (707) 773-4646 > > ******************************************** > 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
