Forum Discussion
Dynamic Row Level Security - Data schema issue
Hello, I am struggling to implement dynamic row-level security access to my data model. I have identified two relationships that are causing the problem (see highlighted in image below). If eithe...
You should avoid bi-directional filters. The one is likely needed for RLS in your case, but you should learn how to pass filters around with CROSSFILTER or TREATAS to avoid bi-di relationships, when possible. Can you go straight from the User Location Table to the Org Mapping table on location_id?
Pat
Hi Pat,
Thank you for your reply. I will take a look into CROSSFILTER and TREATAS. I am able to connect from the user location table to the org mapping table on location_idS. Unfortunately, I am running into the same issue as before with this new relationship.