nxql all values in set
All - I need to build an NXQL query that returns only the set of documents for which ALL values of a given multi-valued document schema property are in a set of values. E.g.:
If principal A is allowed to see BLUE and GREEN then pseudo-nxql is:
select * from document where ALL occurrences of document.colors in ('BLUE', 'GREEN') and so a document having BLUE and YELLOW would be excluded. But principal B has BLUE, GREEN, and YELLOW and so is allowed access because the pseudo-nxql would be:
select * from document where ALL occurrences of document.colors in ('BLUE', 'GREEN', YELLOW'). In other words the constraint list is driven by the principal's entitlements which can change at any time.
Conceptually it's left outer join from document (L) to principal ® with no NULL on the principal side of the join.
I don't think NXQL supports this but - in case I missed something - I thought I would ask. Thank you.