As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
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!
Today NXQL does not allow IS NULL / IS NOT NULL checks on collections. You can do it using CMISQL though (NXP-12642).
IS NULL
IS NOT NULL