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
