CMIS CONTAINS Problem
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
The CMIS spec disallows it. See CMIS 1.1, §22.214.171.124.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.