I'm seeking assistance with creating a restriction in BR Query to control access to a table based on pending ticket assignments.
Here's the scenario:
We aim to restrict users with a role ("restricted_itil") from accessing a table if they lack any pending tickets assigned to them or their assignment group. This context is crucial for managing access for external users who are granted the "restricted_itil" role. They should have access to specific tables, such as incident tables, RITM, and Change Requests, but only if there are pending tickets assigned to them or their assignment group.
For clarity, if an external user under the "restricted_itil" role doesn't have any pending incident tickets assigned to them or their assignment group, they shouldn't be able to access the incident table, same goes to (RITM and CHR).
We tried this in ACL but this post reply tells us not to use ACL and therefore use BR Query:
https://www.servicenow.com/community/itsm-forum/acl-for-table-restriction-when-user-is-given-a-speci...
Now, I'm looking for guidance on how to initiate the creation of such restrictions within BR Query. Any insights or examples on how to start implementing this logic would be immensely helpful.
