topic Re: cmis CONTAINS with * wildcard and trailing space in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/cmis-contains-with-wildcard-and-trailing-space/m-p/311610#M264740 <HTML><HEAD></HEAD><BODY><SPAN>The expression you embedded in CMIS-SQL using the contains() predicate function is full text search query text .</SPAN><BR /><SPAN>If you use 'cp<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />Titolo:allegat *'(with trailing space),alfresco will treat it as two terms(phrases) combined using "OR"("OR" is the default connective),then it will match all documents of type "cp:metadatiPratica".</SPAN><BR /></BODY></HTML> Fri, 21 Mar 2014 16:58:50 GMT kaynezhang 2014-03-21T16:58:50Z cmis CONTAINS with * wildcard and trailing space https://connect.hyland.com/t5/alfresco-archive/cmis-contains-with-wildcard-and-trailing-space/m-p/311609#M264739 Dear All,I'm experiencing a strange behaviour with this cmis query:select * from cp:myAspect&nbsp; where CONTAINS&nbsp; ('cp<IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />Title:foobar*')Basically I want everything matching a Title containing 'foobar' then anything. The above query works as expected.If then I issue:select * from cp:metadatiPratica&nbsp; where Thu, 20 Mar 2014 10:23:25 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-contains-with-wildcard-and-trailing-space/m-p/311609#M264739 pluttero 2014-03-20T10:23:25Z Re: cmis CONTAINS with * wildcard and trailing space https://connect.hyland.com/t5/alfresco-archive/cmis-contains-with-wildcard-and-trailing-space/m-p/311610#M264740 <HTML><HEAD></HEAD><BODY><SPAN>The expression you embedded in CMIS-SQL using the contains() predicate function is full text search query text .</SPAN><BR /><SPAN>If you use 'cp<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />Titolo:allegat *'(with trailing space),alfresco will treat it as two terms(phrases) combined using "OR"("OR" is the default connective),then it will match all documents of type "cp:metadatiPratica".</SPAN><BR /></BODY></HTML> Fri, 21 Mar 2014 16:58:50 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-contains-with-wildcard-and-trailing-space/m-p/311610#M264740 kaynezhang 2014-03-21T16:58:50Z