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.