I was wondering if it is possible to create a set from a query in DomEL.
My example goes a little like this
now my idea is to show rows that match these filters:
orders.user_id IN (select user_id from users) OR orders.division_id IN (select division_id from users) OR orders.division_parent_id IN (select division_id from users)
Why do I want this? The idea is to then have a row-level access to the users file (so only showing the current user from table users). Such I would create a domain that only shows the orders that the current user is allowed to see (more than his personal orders)
Any idea how I could achieve this?
Any input welcom and thanks a lot,