https://connect.hyland.com/t5/nuxeo-forum/nxql-test-collection-has-children/m-p/324700#M11701 <P>Hi all, how to query (nxql) if a collection is empty or not?</P> <P>I'd like something like this: select * from Document where dc:subjects is not null (but the clause "is not null" is not admitted)</P> <P>tnx!</P> Tue, 22 Oct 2013 09:50:36 GMT maumig_ 2013-10-22T09:50:36Z https://connect.hyland.com/t5/nuxeo-forum/nxql-test-collection-has-children/m-p/324700#M11701 <P>Hi all, how to query (nxql) if a collection is empty or not?</P> <P>I'd like something like this: select * from Document where dc:subjects is not null (but the clause "is not null" is not admitted)</P> <P>tnx!</P> Tue, 22 Oct 2013 09:50:36 GMT https://connect.hyland.com/t5/nuxeo-forum/nxql-test-collection-has-children/m-p/324700#M11701 maumig_ 2013-10-22T09:50:36Z https://connect.hyland.com/t5/nuxeo-forum/nxql-test-collection-has-children/m-p/324701#M11702 <P>Today NXQL does not allow <CODE>IS NULL</CODE> / <CODE>IS NOT NULL</CODE> checks on collections. You can do it using CMISQL though (<A href="https://jira.nuxeo.com/browse/NXP-12642">NXP-12642</A>).</P> Tue, 22 Oct 2013 12:56:20 GMT https://connect.hyland.com/t5/nuxeo-forum/nxql-test-collection-has-children/m-p/324701#M11702 Florent_Guillau 2013-10-22T12:56:20Z