> > How are the date properties indexed? This is configured in the > repository's domain.xml [1]. You can specifically tell the > repository to > index a certain property as date, maybe you can try this. > Although with > a yyyyMMdd format string indexing/sorting should also work. > > Maybe someone with more knowledge of repository/lucene can shed some > light on this (Ard? Bart?).
You are correct: if you are indexing an extracted property that looks like yyyyMMdd, there is no need to configure this seperately in the domain.xml. Lucene can only sort by lexical order. Apart from some known webdav date formats, you need to extract a property in either one of these webdav formats, and define them in domain.xml to be a "date", OR, much simpler and how we normally do it, extract them in a lexical way that sorting is correct. For example, yyyyMMdd yyyyMMddHHmmssSSS etc Hope this clears things up, Regards Ard > > Regards, > Niels > > [1] > http://www.hippocms.org/display/CMS/06.+Using+DASL+Queries#06. > UsingDASLQueries-SlideNamespaceConfiguration > > > > > > Thanks, > > > > Eugene > > > > > > Jasha Joachimsthal wrote: > >> Hi Eugene, > >> > >> mm is for minutes, MM for months. > >> If you change the sort from the date property to index or > xcaption., do > >> you get a sorted result then? > >> Are you sure the date property is set (does it return a > value in your > >> dasl result)? > >> > >> Jasha Joachimsthal > >> > >> Hippo > >> Oosteinde 11 > >> 1017 WT Amsterdam > >> The Netherlands > >> +31 (0)20 5224466 > >> > >> www.hippo.nl > >> > >> > >>> -----Original Message----- > >>> From: [EMAIL PROTECTED] > >>> [mailto:[EMAIL PROTECTED] On Behalf Of > >>> Eugene Fabrikant > >>> Sent: dinsdag 18 september 2007 20:45 > >>> To: Hippo CMS development public mailinglist > >>> Subject: [HippoCMS-dev] Date format in templates > >>> > >>> Hello Friendly Hippos, > >>> > >>> I'm having an issue with a DASL query that sorts on a date > >>> field. I get all kinds of random sorting that bear no > >>> relation to ascending or descending date orders. Currently > >>> I'm storing the date field in yyyymmdd format. Is this > >>> incorrect perhaps? > >>> > >>> TIA, > >>> > >>> -- > >>> Eugene Fabrikant > >>> Bluenog > >>> > >>> 732-733-1120 x108 (w) 732-733-1139 (f) > >>> 973-722-4538 (c) bluenogef (Y!IM, AIM) > >>> [EMAIL PROTECTED] www.bluenog.com > >>> > >>> ******************************************** > >>> Hippocms-dev: Hippo CMS development public mailinglist > >>> > >>> > >> ******************************************** > >> Hippocms-dev: Hippo CMS development public mailinglist > >> > > > > > > ******************************************** > Hippocms-dev: Hippo CMS development public mailinglist > ******************************************** Hippocms-dev: Hippo CMS development public mailinglist
