JPQL security constraints on hierarchical entity


Right now i am working on project with in I want to implement hierarchical entity:
BillingGroup with attributes: parent (Many to One : BillingGroup), managers (Many to Many : Sec$User).
And here problem i faced:
I couldn’t actually figure out, how to write groups Constraint for user like:
If user is manager of parent Billing Group than he can see all child Billing Groups (for example).

Hi Ivan,

You can find an example in the framework code and documentation: it’s sec$User, sec$Group and sec$GroupHierarchy entities. The latter links each Group with all its parents which enables quick searching the hierarchy up and down. An example of using it is here: Creating Local Administrators.