topic Re: FreetextSearch Article Validity [MIN TO NOW] issue in Alfresco Archive

FreetextSearch Article Validity [MIN TO NOW] issue

sivaanagha — Wed, 14 Mar 2012 13:37:50 GMT

In FreetextSearch for article validity using '@cm\:from:[MIN TO NOW]' , but it is not checking the Time (hours, mins).how can i check the date & time?Thanks,Siva.

Re: FreetextSearch Article Validity [MIN TO NOW] issue

afaust — Wed, 14 Mar 2012 21:08:10 GMT

Hello Siva,

Alfresco by default does not index the time fragment, so you can not perform a range query that respects hours / minutes out-of-the-box. With a simple configuration change, you can enable this (it is disabled by default for performance reasons as far as I know). Please have a look at Andy Hinds Blog.

Regards
Axel

Re: FreetextSearch Article Validity [MIN TO NOW] issue

hemantkpn — Wed, 14 Mar 2012 23:21:16 GMT

Hi Siva,

Just replace your code '@cm\:from:[MIN TO NOW]' with

SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss");
String currentDateTime = dateFormat.format(new Date());
"@cm\\:from:[MIN TO" + currentDateTime + "]";

Basically you have to replace NOW with current time stamp in the required format as above.
NOW by default referes to the date and not the time stamp.

- Hemant

Re: FreetextSearch Article Validity [MIN TO NOW] issue

afaust — Thu, 15 Mar 2012 08:19:46 GMT

"NOW" already is the current time stamp including the time, which is only used / effective when Lucene has been configured for millisecond resolution. There is no need to change NOW into anything else. Contrary to the previous comment, "TODAY" is the keyword for the current date without time fragment when Lucene has been configured for millisecond resolution.

The classes DateTokenFilter / DateTimeTokenFilter define how these special tokens are evaluated.

Re: FreetextSearch Article Validity [MIN TO NOW] issue

sivaanagha — Mon, 19 Mar 2012 12:30:05 GMT

tried with above approaches but no luck, please suggest any alternate way.

regards,
Siva.

Re: FreetextSearch Article Validity [MIN TO NOW] issue

afaust — Mon, 19 Mar 2012 13:20:27 GMT

Hello Siva,

just to make sure: Did you modify / adapt the file dataTypeAnalyzers.properties and perform a full index rebuild?

Regards
Axel

Re: FreetextSearch Article Validity [MIN TO NOW] issue

andy — Mon, 19 Mar 2012 21:02:46 GMT

Hi

What version of Alfresco are you using?

Andy

Re: FreetextSearch Article Validity [MIN TO NOW] issue

sivaanagha — Tue, 20 Mar 2012 06:07:21 GMT

Hi Axel,

i am using Alfresco 3.4.5 Enterprise version.

modified the dataTypeAnalyzers.properties as below

d_dictionary.datatype.d_date.analyzer=org.alfresco.repo.search.impl.lucene.analysis.DateAnalyser
d_dictionary.datatype.d_datetime.analyzer=org.alfresco.repo.search.impl.lucene.analysis.DateTimeAnalyser

Thanks,
Siva.

Re: FreetextSearch Article Validity [MIN TO NOW] issue

sivaanagha — Fri, 13 Apr 2012 09:45:10 GMT

Hi All,

Modified the dataTypeAnalyzers.properties as below

d_dictionary.datatype.d_date.analyzer=org.alfresco.repo.search.impl.lucene.analysis.DateAnalyser
d_dictionary.datatype.d_datetime.analyzer=org.alfresco.repo.search.impl.lucene.analysis.DateTimeAnalyser

And added below entry in alfresco-global.properties file

index.recovery.mode=FULL

Then performed full index rebuild. Now date & time is working fine for search.

Thanks,
Siva.