nxql test collection has children

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!

0 votes

1 answers

969 views

ANSWER



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

0 votes