topic How to add low-level SQL where-clause constraints to a Nuxeo SecurityPolicy SQLQuery? in Nuxeo Forum https://connect.hyland.com/t5/nuxeo-forum/how-to-add-low-level-sql-where-clause-constraints-to-a-nuxeo/m-p/328370#M15371 <P>I am looking to implement a work-around for <A href="https://jira.nuxeo.com/browse/NXP-10182">NXP-10182</A> by using triggers to maintain several array columns thereby eliminating join overhead. The where clause of the SQLQuery in my SecurityPolicy needs to reference these array columns. Any recommendation how I can augment the WhereClause to include my low-level SQL where-clause constraints that include dialect-specific array operators?</P> Fri, 22 Feb 2013 18:55:27 GMT ron_1 2013-02-22T18:55:27Z How to add low-level SQL where-clause constraints to a Nuxeo SecurityPolicy SQLQuery? https://connect.hyland.com/t5/nuxeo-forum/how-to-add-low-level-sql-where-clause-constraints-to-a-nuxeo/m-p/328370#M15371 <P>I am looking to implement a work-around for <A href="https://jira.nuxeo.com/browse/NXP-10182">NXP-10182</A> by using triggers to maintain several array columns thereby eliminating join overhead. The where clause of the SQLQuery in my SecurityPolicy needs to reference these array columns. Any recommendation how I can augment the WhereClause to include my low-level SQL where-clause constraints that include dialect-specific array operators?</P> Fri, 22 Feb 2013 18:55:27 GMT https://connect.hyland.com/t5/nuxeo-forum/how-to-add-low-level-sql-where-clause-constraints-to-a-nuxeo/m-p/328370#M15371 ron_1 2013-02-22T18:55:27Z