nxql test collection has children

[maumig_]

Hi all, how to query (nxql) if a collection is empty or not?

I'd like something like this: select * from Document where dc:subjects is not null (but the clause "is not null" is not admitted)

tnx!

[Florent_Guillau]

Today NXQL does not allow IS NULL / IS NOT NULL checks on collections. You can do it using CMISQL though (NXP-12642).