https://connect.hyland.com/t5/nuxeo-forum/nxql-all-values-in-set/m-p/314074#M1075 <P>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.:</P> <P>If principal A is allowed to see <STRONG>BLUE</STRONG> and <STRONG>GREEN</STRONG> then pseudo-nxql is: <CODE>select * from document where ALL occurrences of document.colors in ('BLUE', 'GREEN')</CODE> and so a document having <STRONG>BLUE</STRONG> and <STRONG>YELLOW</STRONG> would be excluded. But principal B has <STRONG>BLUE</STRONG>, <STRONG>GREEN</STRONG>, and <STRONG>YELLOW</STRONG> and so is allowed access because the pseudo-nxql would be: <CODE>select * from document where ALL occurrences of document.colors in ('BLUE', 'GREEN', YELLOW')</CODE>. In other words the constraint list is driven by the principal's entitlements which can change at any time.</P> <P>Conceptually it's left outer join from document (L) to principal (R) with no NULL on the principal side of the join.</P> <P>I don't think NXQL supports this but - in case I missed something - I thought I would ask. Thank you.</P> Fri, 14 May 2021 14:54:01 GMT Eric_Ace 2021-05-14T14:54:01Z https://connect.hyland.com/t5/nuxeo-forum/nxql-all-values-in-set/m-p/314074#M1075 <P>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.:</P> <P>If principal A is allowed to see <STRONG>BLUE</STRONG> and <STRONG>GREEN</STRONG> then pseudo-nxql is: <CODE>select * from document where ALL occurrences of document.colors in ('BLUE', 'GREEN')</CODE> and so a document having <STRONG>BLUE</STRONG> and <STRONG>YELLOW</STRONG> would be excluded. But principal B has <STRONG>BLUE</STRONG>, <STRONG>GREEN</STRONG>, and <STRONG>YELLOW</STRONG> and so is allowed access because the pseudo-nxql would be: <CODE>select * from document where ALL occurrences of document.colors in ('BLUE', 'GREEN', YELLOW')</CODE>. In other words the constraint list is driven by the principal's entitlements which can change at any time.</P> <P>Conceptually it's left outer join from document (L) to principal (R) with no NULL on the principal side of the join.</P> <P>I don't think NXQL supports this but - in case I missed something - I thought I would ask. Thank you.</P> Fri, 14 May 2021 14:54:01 GMT https://connect.hyland.com/t5/nuxeo-forum/nxql-all-values-in-set/m-p/314074#M1075 Eric_Ace 2021-05-14T14:54:01Z