Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Organizational Hierarchy - Row Level Security

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. 

 

 

2 Replies