topic cmis-alfresco search providing incorrect results in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/cmis-alfresco-search-providing-incorrect-results/m-p/312654#M265784 <HTML><HEAD></HEAD><BODY><P>When using a Node Browser cmis-alfresco search certain characters appear to be interpreted as wild cards:</P><P></P><P>As an example, a folder exists in Alfresco named ANameFollowedbyaChar“SecondName.Given “ is an illegal search (results in 09170367 line 1:42 no viable alternative at character '“'), this is replaced in the search with _x20ac_</P><P></P><P>SELECT cmis<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ath FROM cmis:folder WHERE IN_TREE('AFolder' ) AND CONTAINS('cmis:name:ANameFollowedbyaChar_x20ac_SecondName*')</P><P></P><P>the search locates the folder , but would also locate a folder with a similar name, e..g ANameFollowedbyaChar€SecondName.</P><P></P><P>The search appears to be using _x20ac_ as a wildcard. This behavior is consistent when search for several non standard chars.e.g when using values “ (_x20ac_) , €&nbsp;&nbsp;&nbsp; (_x201c _) , -(_x002D_) in the search statement&nbsp; , the folder ANameFollowedbyaChar“SecondName would be located.</P><P></P><P>Why is the search treating these values as a wildcards ?</P></BODY></HTML> Mon, 17 Oct 2016 14:15:34 GMT jas_bolton 2016-10-17T14:15:34Z cmis-alfresco search providing incorrect results https://connect.hyland.com/t5/alfresco-archive/cmis-alfresco-search-providing-incorrect-results/m-p/312654#M265784 When using a Node Browser cmis-alfresco search certain characters appear to be interpreted as wild cards:As an example, a folder exists in Alfresco named ANameFollowedbyaChar“SecondName.Given “ is an illegal search (results in 09170367 line 1:42 no viable alternative at character '“'), this is repla Mon, 17 Oct 2016 14:15:34 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-alfresco-search-providing-incorrect-results/m-p/312654#M265784 jas_bolton 2016-10-17T14:15:34Z Re: cmis-alfresco search providing incorrect results https://connect.hyland.com/t5/alfresco-archive/cmis-alfresco-search-providing-incorrect-results/m-p/312655#M265785 <HTML><HEAD></HEAD><BODY><P>These characters are NOT treated as wildcards but as simple punctuation characters which will be treated basically just like a whitespace would in CONTAINS queries. This is a feature of the full text search engine and intended. If you use exact match queries with = then those characters are treated as unique literals and will not cause these kind of matches.</P></BODY></HTML> Mon, 17 Oct 2016 14:56:37 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-alfresco-search-providing-incorrect-results/m-p/312655#M265785 afaust 2016-10-17T14:56:37Z