topic Alfresco CMIS query working with AND but not with OR in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-cmis-query-working-with-and-but-not-with-or/m-p/293298#M246428 <HTML><HEAD></HEAD><BODY><BR /><BR /><SPAN>I'm trying to get search result in alfresco using cmis query.</SPAN><BR /><BR /><SPAN>The below query runs fine and returns result</SPAN><BR /><BR /><SPAN>SELECT * FROM my:content WHERE (cmis:name Like '%a%' And my:description Like '%a%')</SPAN><BR /><BR /><SPAN>whereas the same query with OR condition doesn't return any result.</SPAN><BR /><BR /><SPAN>SELECT * FROM my:content WHERE (cmis:name Like '%a%' OR my:description Like '%a%')</SPAN><BR /><BR /><SPAN>Please Help. Thanks in advance.</SPAN><BR /></BODY></HTML> Mon, 11 Apr 2016 11:19:26 GMT alfresco_shaikh 2016-04-11T11:19:26Z Alfresco CMIS query working with AND but not with OR https://connect.hyland.com/t5/alfresco-archive/alfresco-cmis-query-working-with-and-but-not-with-or/m-p/293298#M246428 I'm trying to get search result in alfresco using cmis query.The below query runs fine and returns resultSELECT * 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 Lik Mon, 11 Apr 2016 11:19:26 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-cmis-query-working-with-and-but-not-with-or/m-p/293298#M246428 alfresco_shaikh 2016-04-11T11:19:26Z Re: Alfresco CMIS query working with AND but not with OR https://connect.hyland.com/t5/alfresco-archive/alfresco-cmis-query-working-with-and-but-not-with-or/m-p/293299#M246429 <HTML><HEAD></HEAD><BODY><SPAN>This is cross-posted on Stack here:</SPAN><BR /><A href="http://stackoverflow.com/questions/36547141/alfresco-cmis-query-working-with-and-but-not-with-or" rel="nofollow noopener noreferrer">http://stackoverflow.com/questions/36547141/alfresco-cmis-query-working-with-and-but-not-with-or</A></BODY></HTML> Mon, 11 Apr 2016 18:30:20 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-cmis-query-working-with-and-but-not-with-or/m-p/293299#M246429 jpotts 2016-04-11T18:30:20Z