Alfresco CMIS query working with AND but not with OR

Question

I'm trying to get search result in alfresco using cmis query.

The below query runs fine and returns result

SELECT * FROM my:content WHERE (cmis:name Like '%a%' And my:description Like '%a%')

whereas the same query with OR condition doesn't return any result.

SELECT * FROM my:content WHERE (cmis:name Like '%a%' OR my:description Like '%a%')

Please Help. Thanks in advance.

Is my:description an attribute of a type named my:content or is it defined in an aspect? — Jeff Potts
@JeffPotts cmis endpoint : localhost:8080/alfresco/service/cmis — User14141111
@JeffPotts my description is property <property name="my:description"> <title>Description</title> <type>d:mltext</type></property> — User14141111

Jeff Potts Jeff Potts · Accepted Answer · 2016-04-13T14:08:17

You are not using the correct CMIS endpoint. For Alfresco, 4.2, you need to use one of the following:

ATOM Pub Binding, CMIS 1.0:

http://<host>/alfresco/api/-default-/public/cmis/versions/1.0/atom

ATOM Pub Binding, CMIS 1.1:

http://<host>/alfresco/api/-default-/public/cmis/versions/1.1/atom

Browser (JSON) Binding, CMIS 1.1:

http://<host>/alfresco/api/-default-/public/cmis/versions/1.1/browser

Using the correct binding, I cannot re-create this problem.