Organizational Hierarchy - Row Level Security

[Anonymous]

Hi.

I have been trying to figure out dynamic row level security, I have already created a Path function between the employee ID and Manager ID, but that solution was not accepted as that is missing some numbers that were not added to the manager - employee hierarchical structure.

I have been asked to create row level security based off of the bottom fields 1 2 3 and 4 in terms of hierarchical structure, the last 3 columns are path functions between the 4 columns. 

My Question is, is it possible to create a path that can link all 4 columns together for a hierarchical view to filter the data? I have looked long and hard for row level security solutions but I cannot find anything that creates a path using 3 or more columns, only 2. Would greatly appreciate any help towards this, I have been looking for a long time trying to figure out how to link multiple columns together for the row level security. Thank you.

Edit: Sorry, I realize that 3 and 4 were swapped around in terms of ordering. 

[v-easonf-msft]

Hi, @Anonymous 

Has the problem been solved so far? If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Anonymous , refer if this can help

https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies