topic Re: Date range in lucene query in Alfresco Archive

Date range in lucene query

cperez — Tue, 23 Sep 2014 17:48:32 GMT

Hi allI need to incorporate a lucene Serach for docs in a specified location on a particular date range (from fixed date to today less 1 hour). I have used the following lucene query but I get all the documents modified to the same moment as the query is executed.var today = new Date();//Start datev

Re: Date range in lucene query

mitpatoliya — Wed, 24 Sep 2014 06:53:24 GMT

You need to change date format to combined Date Time format
http://en.wikipedia.org/wiki/ISO_8601#Combined_date_and_time_representations
http://stackoverflow.com/questions/5937017/how-to-convert-a-date-in-this-format-tue-jul-13-000000-cest-2010-to-a-java-d

Re: Date range in lucene query

cperez — Wed, 24 Sep 2014 12:40:00 GMT

Sorry, but I don't understand you.

My range query is :


@cm:modified:["2010-00-01T00:00:00" TO "2014-09-24T10:00:00"]
‍‍‍

But I get documents modified out of that range (for example,modified at 2014-09-24T11:35:00).

Re: Date range in lucene query

cperez — Wed, 24 Sep 2014 13:00:46 GMT

I find in http://blogs.alfresco.com/wp/developer/2011/02/01/whats-in-a-date/ that by default the indexes only works with years, months and days. And is necesary to active hour and minutes to be indexed.

Is this correct??

I search in my server that file "alfresco/model/dataTypeAnalyzers.properties", but that not exist because I have a document for each language (like " /opt/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/model/dataTypeAnalyzers_en.properties") and their content not include that line


"d_dictionary.datatype.d_datetime.analyzer=org.alfresco.repo.search.impl.lucene.analysis.DateTimeAnalyser"
‍‍‍

I need to add that line to the file with the language I use and restart alfresco indexes??

can you explain me how to do it in my Alfresco 3.0??

Thanks

Re: Date range in lucene query

kaynezhang — Mon, 29 Sep 2014 02:02:07 GMT

It seems the solution in this post only works after alfresco community 3.3.
Your alfresco version is a little old,maybe upgrading to a newer version is a better solution.Since alfresco 4 you don't need any additional configuration,the solr search system by default uses the date time analyzer for d:datetime.