cancel
Showing results for 
Search instead for 
Did you mean: 

Alfresco CMIS query working with AND but not with OR

alfresco_shaikh
Champ in-the-making
Champ in-the-making


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.
1 REPLY 1