Forum Discussion
Dynamic RLS in One to many relationship
5. In the "Filter" section, click "Add filter" and select the "B Count" measure you created in step 1. Choose the appropriate operator (e.g. "is greater than" or "is equal to") and enter the appropriate value to control access to the data in Table C based on the related data in Table B.
6. Click "OK" to save your RLS filter and apply it to your report.
This approach uses a measure to indirectly filter Table C based on the related data in Table B. The measure calculates the number of related rows in Table B for each row in Table C, and the RLS filter uses this measure to control access to the data in Table C.
Let me know if you might need further assistance.
What does it mean ? enter the appropriate value to control access to the data in Table C based on the related data in Table B.
Can you please clarify above point
It means that you will need to determine a specific numerical value that will be used to filter the data in Table C. This value will be based on the number of related rows in Table B that are associated with each row in Table C, as calculated by the measure you created in step 1.
For example, if you want to restrict access to Table C to only those rows that have at least 5 related rows in Table B, you would enter the value "5" in the RLS filter using the appropriate operator (e.g. "is greater than or equal to"). This would ensure that only users who have permission to access at least 5 related rows in Table B can see the corresponding rows in Table C.
Hope this helps.
But it can be any number as its dynamic. There is another role which i created on table B
Mail ID=Userprinicipalname()
I think we need to use mail id column on table C. Can you please share views on this.