topic lucene date range query not giving perfect results.. in Alfresco Archive

lucene date range query not giving perfect results..

power — Thu, 24 Jun 2010 04:43:25 GMT

Friends,I am using alfresco 3.2r enterprise.I am creating sites from alfresco share by changing system time.like site for 2006, 2007, 2008, 2009, 2010,2011Now I have my two custom properties called startdate and enddate, how do I search my site lies within this range?I read wiki but didnt get exact

Re: lucene date range query not giving perfect results..

g_rathod — Thu, 24 Jun 2010 04:46:12 GMT

Have you tried like below :

for example here


   @st\:startdate:[2010-03-31T00:00:00.000+05:30 TO 2011-04-01T00:00:00.000+05:30 ] AND @st\:enddate:[2010-03-31T00:00:00.000+05:30 TO 2011-04-01T00:00:00.000+05:30]
‍‍‍

try giving different date range according to your date criteria.
does it solve your problem ?

Re: lucene date range query not giving perfect results..

power — Thu, 24 Jun 2010 04:49:28 GMT

Thanks Ghanshyam,

I tried it various way, it helps me a lot,

but since results are yet not perfect filtered thorugh it.

if any solution to get perfect match search through date range??? or alfresco having OOB issue for date range search ?