Nice to Know — CMIS and WebCenter

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

Up ↑

%d bloggers like this: