Section Access: Row-Level-Reduction on multiple fields
Hi,
I am trying to implement section access with row-level reduction based on multiple fields.
We have to maintain 600+ users. We have a team assignment list in SharePoint (name, email, user-id, employee-id, role, team etc.)
The main fact table is call data.
The data reduction should be based on two fields: call_queue and team. For example:
User1: Role = Manager from Team 1 → can see data Team 1–Team 10 and Queue 1–Queue 11
User2: Role = Team Coordinator from Team 2 → can see Team 2 only and Queue 1–Queue 11
I want to know if it is possible to dynamically create data reduction based on the SharePoint list. At the moment each row in the SharePoint list corresponds to one employee and one team (no call queue).
Depending on the user’s role, they may have access to several teams and queues.
Also, the call_queue field is part of the Call fact table and is not in the team assignment SharePoint list.
Is there any good example using sharepoint list for dynamic row-level-security on multiple fields?
