topic Re: Date Sorting via Lucene in Web Script in Alfresco Archive

Date Sorting via Lucene in Web Script

howejr77 — Fri, 07 Nov 2008 18:24:44 GMT

We have a Java backed web script which is running a lucene query and attempting to sort against a date property which is populated via metadata extraction in WCM. We are encountering an issue where the web script works perfectly in our Authoring environment but when we deploy the content to the Runt

Re: Date Sorting via Lucene in Web Script

andy — Thu, 14 May 2009 19:07:44 GMT

Hi

Are your two environments running the same version of Alfresco?
Have they got the same config?
What date are you sorting on - and are you sure it is not being set to one value as part of the deploy.
Is the meta data correct after deployment?

Andy

Re: Date Sorting via Lucene in Web Script

howejr77 — Thu, 14 May 2009 20:27:43 GMT

Yes, it is the same version of Alfresco. If you look at help ticket 6041, you will see where this is (you may have even helped look into it). We don't know what the problem is but have basically gone done the approach pulling all the children nodes in the webscript, retrieving the custom date parameter and sorting them ourselves.

Basically, the Lucene query would work properly in the authoring environment but in the Runtime environment it would "flip" the first and last entry (if not some more) actually giving us the oldest one first.

We haven't solved this but it has gotten old enough that we've coded away from using Lucene.