Forum Discussion

AG2's avatar
AG2
Frequent Visitor
3 years ago
Solved

Dynamic default report view per user

Hi all,   I have a report that is filtered by business unit within the company. The business unit hierarchy is a ragged hierarchy. There is also row level security (RLS) on the business units so us...
  • AG2's avatar
    3 years ago

    Figured out a solution. I had a new table where I need to manage each user and their starting default value. Then created another table which is per user and per business unit, and use a lookup to get their starting default value. Then from that, created "Defaultlevel1", "Defaultlevel2" so on.. fields that start at their starting default value then get the next path item then put row level security on this new table based on user email.