https://connect.hyland.com/t5/nuxeo-forum/cmis-query-of-unset-multi-valued-property/m-p/313137#M138 <P>If dc:subjects is not set, am I correct that "quantified in predicate" (ANY dc:subjects NOT IN ('foo')) is FALSE? This is because at least one dc:subjects would need to exist that is not 'foo', right?</P> Mon, 30 Sep 2013 08:14:55 GMT rg1_ 2013-09-30T08:14:55Z https://connect.hyland.com/t5/nuxeo-forum/cmis-query-of-unset-multi-valued-property/m-p/313137#M138 <P>If dc:subjects is not set, am I correct that "quantified in predicate" (ANY dc:subjects NOT IN ('foo')) is FALSE? This is because at least one dc:subjects would need to exist that is not 'foo', right?</P> Mon, 30 Sep 2013 08:14:55 GMT https://connect.hyland.com/t5/nuxeo-forum/cmis-query-of-unset-multi-valued-property/m-p/313137#M138 rg1_ 2013-09-30T08:14:55Z https://connect.hyland.com/t5/nuxeo-forum/cmis-query-of-unset-multi-valued-property/m-p/313138#M139 <P>Yes. CMISQL <CODE>ANY</CODE> generates a SQL <CODE>EXISTS</CODE> with a subquery on the given predicate (<CODE>=</CODE> for <CODE>NOT IN</CODE> here).</P> Mon, 30 Sep 2013 12:01:45 GMT https://connect.hyland.com/t5/nuxeo-forum/cmis-query-of-unset-multi-valued-property/m-p/313138#M139 Florent_Guillau 2013-09-30T12:01:45Z