topic Re: Still having problems with datetime resolution queries (FTS/CMIS) in Alfresco Archive

Still having problems with datetime resolution queries (FTS/CMIS)

mreyem — Wed, 16 Apr 2014 08:51:58 GMT

Hi there,I'm currently using Alfresco Community 4.2.c and after a lot of battles I still cannot query my document using datetime resolution. These are the steps that I performed:1) Setting Lucene as indexing system2) Changed datetime analyzer to d_dictionary.datatype.d_datetime.analyzer=org.alfresc

Re: Still having problems with datetime resolution queries (FTS/CMIS)

openpj — Wed, 16 Apr 2014 09:56:56 GMT

For what I know about this, Alfresco doesn't create indexes for hours, minutes and seconds.
This means that you can execute queries only on dates (comparing until the exact day) even if you have to specify the suffix about the hour.

If you want you can enable the indexing process with the hour, please see:
http://blogs.alfresco.com/wp/developer/2011/02/01/whats-in-a-date/

Hope this helps

Re: Still having problems with datetime resolution queries (FTS/CMIS)

kaynezhang — Wed, 16 Apr 2014 14:37:24 GMT

By changing datetime analyzer to DateTimeAnalyser and ) performing a full reindex,I think time will be indexed into lucene.
Have you tried to use time range query


@cm:created:["2014-03-26T14:19:42.000" TO "2014-03-26T14:19:48.000"]
‍‍‍