How to add low-level SQL where-clause constraints to a Nuxeo SecurityPolicy SQLQuery?

I am looking to implement a work-around for NXP-10182 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?

0 votes

0 answers

1466 views

ANSWER