CMIS queries is an extensive topic and I’d like to write about it in other posts, but today I want to mention some important tips regarding CMIS:

1. CMIS stands for “Content Management Interoperability Services”

2. Oracle WebCenter uses OASIS CMIS

3. To work with Multivalued properties remember to use ANY <multiValuedQueryName> IN (<literal>, …).

IT TOOK ME A WHILE TO MAKE IT WORK:

4. To work with more than 2 ORs for the same property in a query, use this syntax:
(( (propertyA LIKE ‘value1’ OR propertyA Like ‘value2’) OR (propertyA LIKE ‘value3’) ))

ex:
SELECT * FROM ora:t:IDC:GlobalProfile WHERE ora:p:dDocType LIKE ‘Demo’ AND (((ora:p:xMyBlog LIKE ‘WebCenter’ OR ora:p:xMyBlog Like ‘Portal) OR (ora:p:xMyBlog LIKE ‘Mauro’)))

5. You need to escape the characters ‘ and _ with: /

If you want more information please refer to:

ORACLE:http://docs.oracle.com/cd/E29542_01/webcenter.1111/e27739/jpsdg_cm_rest.htm

OASIS: http://docs.oasis-open.org/cmis/CMIS/v1.0/cmis-spec-v1.0.html