CMIS Query Full Text with special Characters

[fagnersouza]

I'm doing the CMIS query:

SELECT * FROM xuxu: xuxu_conteudo
WHERE 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 you

Fagner

[andy]

Cmis contains does not support wild cards using %.
The CONTAINS syntax only supports terms and phrases and the exact behaviour as to what is a term is repository specific.

So your query to match 50%  is tokenised to 50 sand matches all docs containing 50 as you say.

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 %.

Andy