cancel
Showing results for 
Search instead for 
Did you mean: 

lucene date range query not giving perfect results..

power
Champ in-the-making
Champ in-the-making
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,2011

Now 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 things.
http://wiki.alfresco.com/wiki/Search#Range_Queries

any help ?
2 REPLIES 2

g_rathod
Star Contributor
Star Contributor
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 ?

power
Champ in-the-making
Champ in-the-making
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 ?