AnsweredAssumed Answered

Strange results in CONTAINS() CMIS search with wildcards

Question asked by juanh on Feb 15, 2018
Latest reply on Mar 1, 2018 by andy1

Hi, everyone

 

I have detected a strange behaviour in CMIS queries using CONTAINS() and wildcards.

For example, I have a folder named "Someco" and I want to find it by part of its name using wildcards:

 

SELECT * from cmis:folder WHERE CONTAINS('cmis:name:"*Some*"')

 

This query find the the folder as is expected, but if I add a 'o' or an 'a' to the query as:

 

SELECT * from cmis:folder WHERE CONTAINS('cmis:name:"*Someo*"')

 

The modified query find my folder too, wich is incorrect as my folder does not contains "Someo" in its name.

 

¿Is there any way to correct this behaviour with the syntaxis of the query?

 

Thanks.

Outcomes