Managing Peer Review Row Level Security Settings

Hi,

Hope someone has a work around for the below. I’m creating league tables where managers at certain levels can compare business KPI’s to their Peers across the network but can only see

  • any levels that feed into their own area
  • the rolled up KPI’s for their peers
  • the rolled up KPI for the level above them.

On the attached picture a manager who runs 4a can see 4a1, 4a2 and 4a3 as well as 4b and 4c but cannot see 4b1 to 4b3 or 4c1 to 4c3.

Any help would be great at this point

I think you would just have to have columns for each of these levels and give people access per column.

You can use multiple columns, and multiple values per column in RLS.