topic Does FTS Query support comparison operators? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/does-fts-query-support-comparison-operators/m-p/306163#M259293 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I'm using FTS search query that has to fetch documents that contains a full text (or keyword) and also based on a specific date (either &lt;, &gt;, &lt;= or &gt;= a specific date). But with these comparison operators, SOLR search throws exception.&nbsp; IS there any equivalent operators for FTS query to perform date comparisons? </SPAN><BR /><BR /><SPAN>This is my FTS query:</SPAN><BR /><BR /><A href="https://localhost:8080/alfresco/s/org/alfresco/xyz/faceted/search?query=(Keywords:" test="Test" rel="nofollow noopener noreferrer">https://localhost:8080/alfresco/s/org/alfresco/xyz/faceted/search?query=(Keywords:'Test')</A><SPAN> AND cmis:creationDate &lt;=&nbsp; '2016-07-07' &amp;count=10&amp;language=fts-alfresco&amp;skip=0&amp;format=json</SPAN><BR /><BR /><SPAN>Exception:</SPAN><BR /><SPAN> "callstack" : </SPAN><BR /><SPAN>&nbsp; [ </SPAN><BR /><SPAN>&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; ""&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,"org.alfresco.repo.search.impl.lucene.LuceneQueryParserException: 07032268 SOLR side error: 07030010 line 1:96\nmismatched input '&lt;EOF&gt;' expecting TO&nbsp; ([@29,96:96='&lt;EOF&gt;',&lt;-1&gt;,1:96])\n\t[ftsQuery, ftsDisjunction, ftsImplicitDisjunction, ftsExplicitConjunction, ftsPrefixed, ftsTest, ftsRange, ftsFieldGroupRange, recoverFromMismatchedToken]"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,"org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.executeQuery(SolrQueryHTTPClient.java:472)"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,"org.alfresco.repo.search.impl.solr.SolrQueryLanguage.executeQuery(SolrQueryLanguage.java:49)"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,"org.alfresco.repo.search.impl.solr.DbOrIndexSwitchingQueryLanguage.executeQuery(DbOrIndexSwitchingQueryLanguage.java:92)"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,"org.alfresco.repo.search.impl.solr.SolrSearchService.query(SolrSearchService.java:348)"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,"org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:78)"</SPAN></BODY></HTML> Wed, 03 Aug 2016 12:00:37 GMT jeevitha_balu 2016-08-03T12:00:37Z Does FTS Query support comparison operators? https://connect.hyland.com/t5/alfresco-archive/does-fts-query-support-comparison-operators/m-p/306163#M259293 Hi,I'm using FTS search query that has to fetch documents that contains a full text (or keyword) and also based on a specific date (either &lt;, &gt;, &lt;= or &gt;= a specific date). But with these comparison operators, SOLR search throws exception.&nbsp; IS there any equivalent operators for FTS query Wed, 03 Aug 2016 12:00:37 GMT https://connect.hyland.com/t5/alfresco-archive/does-fts-query-support-comparison-operators/m-p/306163#M259293 jeevitha_balu 2016-08-03T12:00:37Z Re: Does FTS Query support comparison operators? https://connect.hyland.com/t5/alfresco-archive/does-fts-query-support-comparison-operators/m-p/306164#M259294 <HTML><HEAD></HEAD><BODY><SPAN>You can use a range query for this. For example, "cm:created:[MIN TO 2016-07-07]".</SPAN><BR /><BR /><SPAN>See </SPAN><A href="http://docs.alfresco.com/4.0/concepts/rm-searchsyntax-ranges.html" rel="nofollow noopener noreferrer">http://docs.alfresco.com/4.0/concepts/rm-searchsyntax-ranges.html</A><SPAN>.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Mon, 08 Aug 2016 13:41:55 GMT https://connect.hyland.com/t5/alfresco-archive/does-fts-query-support-comparison-operators/m-p/306164#M259294 jpotts 2016-08-08T13:41:55Z