https://connect.hyland.com/t5/nuxeo-forum/cmis-contains-problem/m-p/325166#M12167 <P>Hi!</P> <P>Guys its possible to use more them one contains in the same query ?</P> <PRE><CODE>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') </CODE></PRE> <P>Regards, Rafael Bueno</P> Mon, 17 Feb 2014 23:05:13 GMT Rafael_Bueno 2014-02-17T23:05:13Z https://connect.hyland.com/t5/nuxeo-forum/cmis-contains-problem/m-p/325166#M12167 <P>Hi!</P> <P>Guys its possible to use more them one contains in the same query ?</P> <PRE><CODE>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') </CODE></PRE> <P>Regards, Rafael Bueno</P> Mon, 17 Feb 2014 23:05:13 GMT https://connect.hyland.com/t5/nuxeo-forum/cmis-contains-problem/m-p/325166#M12167 Rafael_Bueno 2014-02-17T23:05:13Z https://connect.hyland.com/t5/nuxeo-forum/cmis-contains-problem/m-p/325167#M12168 <P>The CMIS spec disallows it. See CMIS 1.1, §2.1.14.2.4.4 (CONTAINS() predicate function):</P> <PRE><CODE>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. </CODE></PRE> Mon, 17 Feb 2014 23:21:25 GMT https://connect.hyland.com/t5/nuxeo-forum/cmis-contains-problem/m-p/325167#M12168 Florent_Guillau 2014-02-17T23:21:25Z