topic Re: CMIS Search by cmis:name and cmis:description case insensitive? in Alfresco Forum

CMIS Search by cmis:name and cmis:description case insensitive?

robobot — Thu, 04 Oct 2018 09:32:37 GMT

Hi there, we are using the alfresco community version 5.2 and we are trying to perform a case insensitive search on the two standard properties cmis:name and cmis:description. Actually when searching for "AAA" only files named "AAA" will be found, not files named "aaa" or "Aaa". In other threads and

Re: CMIS Search by cmis:name and cmis:description case insensitive?

angelborroy — Thu, 04 Oct 2018 09:56:13 GMT

CMIS has no support for insensitive search terms. Modifications in SOLR Model have no effect on your searching results.

You could change to FTS syntax by including the CONTAINS clause in your CMIS query, but tokenisation will be applied and probably you'll find additional results.

Some sample queries using out-of-the-box Alfresco SWSDP sample site:

SELECT * FROM cmis:document WHERE cmis:name like 'meeting%'
0 results

SELECT * FROM cmis:document WHERE CONTAINS('cmis:name:meeting*')
4 results‍‍‍‍‍

Re: CMIS Search by cmis:name and cmis:description case insensitive?

robobot — Thu, 04 Oct 2018 10:05:21 GMT

Thanks for your respone,

but how does alfresco handle case insensitive search then? If i type "AAA" in alfrescos search field (Webapplication), files named "aaa" will also be returned.

Re: CMIS Search by cmis:name and cmis:description case insensitive?

angelborroy — Thu, 04 Oct 2018 10:39:17 GMT

You can use FTS syntax to define your query.

=cm:name:'Meeting*'‍

This will include only documents starting exactly with that case combination.

Using searching box in Web Application, applies default searching parameters, what can't fit your expectations.

Re: CMIS Search by cmis:name and cmis:description case insensitive?

robobot — Thu, 04 Oct 2018 15:43:58 GMT

ok, i got it from your answer. replacing

cmis:name like 'aaa%'

with
CONTAINS('cmis:name:aaa')

now also finds documents having a filename with "AAA". that's the desired result. 

thank you!