topic Re: CMIS Query Full Text with special Characters in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/cmis-query-full-text-with-special-characters/m-p/296233#M249363 <HTML><HEAD></HEAD><BODY><SPAN>Cmis contains does not support wild cards using %.</SPAN><BR /><SPAN>The CONTAINS syntax only supports terms and phrases and the exact behaviour as to what is a term is repository specific.</SPAN><BR /><BR /><SPAN>So your query to match 50%&nbsp; is tokenised to 50 sand matches all docs containing 50 as you say.</SPAN><BR /><BR /><SPAN>Unless you are looking specifically in cmis:name (and not the content) there is not much else you can do other then configure the tokenisation behaviour of d:content to keep %.</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Fri, 12 Apr 2013 20:18:43 GMT andy 2013-04-12T20:18:43Z CMIS Query Full Text with special Characters https://connect.hyland.com/t5/alfresco-archive/cmis-query-full-text-with-special-characters/m-p/296232#M249362 I'm doing the CMIS query<IMG id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />ELECT * FROM xuxu: xuxu_conteudoWHERE CONTAINS ('50%')‍‍‍‍When I run this query, I return all documents that have the number 50. Independent if the "%".How can I do so that the query returns the exact string "50%"?thank youFagner Wed, 03 Apr 2013 22:00:42 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-query-full-text-with-special-characters/m-p/296232#M249362 fagnersouza 2013-04-03T22:00:42Z Re: CMIS Query Full Text with special Characters https://connect.hyland.com/t5/alfresco-archive/cmis-query-full-text-with-special-characters/m-p/296233#M249363 <HTML><HEAD></HEAD><BODY><SPAN>Cmis contains does not support wild cards using %.</SPAN><BR /><SPAN>The CONTAINS syntax only supports terms and phrases and the exact behaviour as to what is a term is repository specific.</SPAN><BR /><BR /><SPAN>So your query to match 50%&nbsp; is tokenised to 50 sand matches all docs containing 50 as you say.</SPAN><BR /><BR /><SPAN>Unless you are looking specifically in cmis:name (and not the content) there is not much else you can do other then configure the tokenisation behaviour of d:content to keep %.</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Fri, 12 Apr 2013 20:18:43 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-query-full-text-with-special-characters/m-p/296233#M249363 andy 2013-04-12T20:18:43Z