CMIS Query with custom property issue

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

mikemars

Hi,

I am running a CMIS Query against an Alfresco Labs 4.0d repository.

The query uses an aspect and a custom property which is a String. The query looks like:

SELECT d.cmis:objectid FROM cmis:document as d join sa:myCustomAspect as g on d.cmis:objectid = g.cmis:objectid  WHERE g.sa:myCustomProperty like 'Hello'
‍‍‍

The query as above executes and finds all the documents which have 'Hello' in the myCustomProperty property. e.g 'Hello', 'Hello World' e.t.c

However, if I change the search string from 'Hello' to 'Hello World', documents which have 'Hello World' set in the property are not returned.

I have tried several different aspect and properties, but each time a search string has a space in it when comparing against a custom property, no results are returned.

As a seperate test I tried a similar query without using a custom property and the results were returned as expected:

SELECT d.cmis:objectid FROM cmis:document as d  WHERE d.cmis:name LIKE 'Hello World'
‍‍‍

Am I missing something from my first query above which will allow it to match against strings with spaces?

Thanks.

jpotts

Try using equals instead of like. Despite what you might think, it isn't an exact match and appears to behave more like a like.

Jeff