Forum Discussion
Dynamic RLS in One to many relationship
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.
- Anonymous3 years agoNot applicable
I tried all available options but unable to acheive correct values for RLS from Table C 😞