Line Manager Dashboard
Summary
Line Manager prompt - Connect by in Logical SQL?Content
Hi Team,
I've added a Line Manager prompt in our custom version of Line Manager Dashboard.
Because some of our Line Managers also have other roles that allow them to see more than their Line Manager role, I've added a logic to the prompt to list only the direct reports for the Line Manager who is logged. That is working fine.
However, our business has asked me to list in that prompt not only the direct manager but also line managers that are in the hierarchy of that particular Line Manager - which means, bring all the hierarchy.