topic Strange results in CONTAINS() CMIS search with wildcards in Alfresco Forum

Strange results in CONTAINS() CMIS search with wildcards

juanh — Thu, 15 Feb 2018 12:01:33 GMT

Hi, everyoneI 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 wildcardsELECT * from cmis:folder WHERE CONTAINS('cmis:name:"*Some*"')‍‍‍This query find the the folder as is e

Re: Strange results in CONTAINS() CMIS search with wildcards

andy1 — Thu, 22 Feb 2018 12:23:55 GMT

I have tried to reproduce this an failed. Are you sure it is finding the same folder!

Andy

Re: Strange results in CONTAINS() CMIS search with wildcards

juanh — Thu, 22 Feb 2018 16:42:00 GMT

Hi, Andy

Yes, I'm sure. It's an issue related to FTS word stemming but I don't know if I can deactivate it in some way.

Thanks

Re: Strange results in CONTAINS() CMIS search with wildcards

andy1 — Thu, 01 Mar 2018 16:59:38 GMT

It seems you are falling foul of localised stemming. The name of a document can be treated as an identifier.

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

Or you could just use LIKE

SELECT * from cmis:folder WHERE cmis:name LIKE '%Some%'

Name is indexed in three ways

Localised with stemming
Split on white space and then into token parts (using WordDelimiter factory)
As a single token (an identifier)

The first two options are used together. You can not split on white space and do a wildcard match on the tokens. You will always get recall from the locale bit (the first way).

It has been suggested before that we support better control here, and it is on the list.

From your example, I think you should be OK with LIKE or =

Andy