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
Leave a Reply