topic CMIS and date time search in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/cmis-and-date-time-search/m-p/270768#M223898 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I have read on wiki(</SPAN><A href="http://wiki.alfresco.com/wiki/CMIS_Query_Language" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/CMIS_Query_Language</A><SPAN> - Section-dateTime) and also observed that Date collation ignores time by default.</SPAN><BR /><BR /><SPAN>I have two records in my repository for which the modified date timestamp is different.</SPAN><BR /><SPAN>Content-1 modification date - 2011-12-16T</SPAN><STRONG>14:17:44.815+05:30</STRONG><BR /><SPAN>Content-2 modification date - 2011-12-16T</SPAN><STRONG>14:25:48.108+05:30</STRONG><BR /><BR /><SPAN>My below CMIS query : </SPAN><PRE class="language-none line-numbers"><CODE>SELECT * FROM cmis:document WHERE cmis:lastModificationDate &gt; TIMESTAMP '2011-12-15T14:20:00.000-00:00' <SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>is always returning me the above 2 records. It is not considering the timestamp for search and doing search based on date only. As per the timestamp in the query I should have got Content-2 as a result only.</SPAN><BR /><BR /><SPAN>I want to search based on timestamp. Could anyone please help me on this.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN></BODY></HTML> Fri, 16 Dec 2011 09:32:03 GMT romschn 2011-12-16T09:32:03Z CMIS and date time search https://connect.hyland.com/t5/alfresco-archive/cmis-and-date-time-search/m-p/270768#M223898 Hi,I have read on wiki(http://wiki.alfresco.com/wiki/CMIS_Query_Language - Section-dateTime) and also observed that Date collation ignores time by default.I have two records in my repository for which the modified date timestamp is different.Content-1 modification date - 2011-12-16T14:17:44.815+05:3 Fri, 16 Dec 2011 09:32:03 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-and-date-time-search/m-p/270768#M223898 romschn 2011-12-16T09:32:03Z Re: CMIS and date time search https://connect.hyland.com/t5/alfresco-archive/cmis-and-date-time-search/m-p/270769#M223899 <HTML><HEAD></HEAD><BODY><SPAN>Assuming you are not using SOLR have you changed your lucene analyzer and reindexed?</SPAN></BODY></HTML> Fri, 16 Dec 2011 09:36:42 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-and-date-time-search/m-p/270769#M223899 mrogers 2011-12-16T09:36:42Z Re: CMIS and date time search https://connect.hyland.com/t5/alfresco-archive/cmis-and-date-time-search/m-p/270770#M223900 <HTML><HEAD></HEAD><BODY><SPAN>I am not using SOLR. Currently I am using alfresco v 3.4.3.</SPAN><BR /><BR /><SPAN>Could you please let me know which classes/changes I will be required to do the LuceneAnalyzer? </SPAN><BR /><BR /><SPAN>I have analyzed that modified date is using org.alfresco.repo.search.impl.lucene.analysis.DateTimeAnalyser class.</SPAN><BR /><SPAN>Could you please let me know which changes are required to it?</SPAN><BR /><BR /><SPAN>Awaiting your reply.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN></BODY></HTML> Fri, 16 Dec 2011 09:44:23 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-and-date-time-search/m-p/270770#M223900 romschn 2011-12-16T09:44:23Z Re: CMIS and date time search https://connect.hyland.com/t5/alfresco-archive/cmis-and-date-time-search/m-p/270771#M223901 <HTML><HEAD></HEAD><BODY><SPAN>Please read the last paragraph on the document you referenced or ALF-5378</SPAN></BODY></HTML> Fri, 16 Dec 2011 09:46:23 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-and-date-time-search/m-p/270771#M223901 mrogers 2011-12-16T09:46:23Z