drill down for Direct Managers in PPM
We have an requirement to show the details of users in drill down way. Like if we provide the manager user id then we have to display the users and if any one of that user is manager then we have to show the users under him. Just like an Hierarchy way. Please find the attached image for your reference. Is there any one who performed this scenario in their report kindly please send me the details so that it will be really help ful to me..
Re: drill down for Direct Managers in PPM
Here is a query you can use to return the info you are looking for. You just need to replace the name of the top level manager.
SELECT lpad(full_name, LENGTH(full_name) + LEVEL * 2 - 2) full_name FROM knta_users WHERE 1=1 START WITH upper(full_name) IN upper('Manager Name') CONNECT BY PRIOR user_id = manager_user_id ORDER SIBLINGS BY first_name, last_name;