AnsweredAssumed Answered

Alfresco CMIS query working with AND but not with OR

Question asked by alfresco_shaikh on Apr 11, 2016
Latest reply on Apr 11, 2016 by jpotts


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.

Outcomes