Home

lucene date range query not giving perfect results..

You are here

3 posts / 0 new
Last post
lucene date range query not giving perfect results..

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 ?

by :
power_user
UK- Leeds

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

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 ?

Ghanshyam Rathod
Senior Consultant
CIGNEX Datamatics Pvt Ltd
INDIA
http://alfrescocms.blogspot.in/
<< click Yes if given forum post is useful >>

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

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 ?

by :
power_user
UK- Leeds