I have successfully applied section access in my app för so called Business Unit Managers.
Business Unit Managers have a number of cost centres they have access to. This works fine.
The thing is, I want the next level in the organisational hierarchy, Business Area Managers, to see all their Business Units, and I want the next level up again, Division Managers, to see all their Business Units.
I have a table with columns for each Hierarchy (1 highest 3 lowest)and person responsible:
Level 1
Level 1 Manager Employee number
Level 2
Level 2 Manager Employee number
Level 3
Level 3 Manager Employee number
Cost Centre (level 4)
Level 4 Manager Employee number no access
IB
123456
IBB
123457
IBB
123458
95515
123459
IB
456789
IBB
456791
IBB5
456791
95518
456795
I have looked at posts about nodes and trees but I don't understand how to apply it.
Sometimes a lower level of hierarchy has the same name as the parent and sometimes the same manager is on a number of levels in the same, or other hierarchies.
Very grateful for help getting my head around this!
