CMIS CONTAINS Problem

Hi!

Guys its possible to use more them one contains in the same query ?

select d.*, o.* from cmis:document as d join cm:titled as o on d.cmis:objectid = o.cmis:objectid where CONTAINS(d,'cmis:name:test OR cmis:createdBy:admin') OR CONTAINS(o,'cm:title:test')

Regards, Rafael Bueno

0 votes

1 answers

2170 views

ANSWER



The CMIS spec disallows it. See CMIS 1.1, §2.1.14.2.4.4 (CONTAINS() predicate function):

At most one CONTAINS() function MUST be included in a single query statement.
The repository MUST throw an exception if more than one CONTAINS() function is found.
0 votes