Nimmakayala Trusted Contributor.
Trusted Contributor.

drill down for Direct Managers in PPM

Hi ,

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..




1 Reply
Derek Giedd Honored Contributor.
Honored Contributor.

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;
-- Remember to give Kudos to answers! (click the KUDOS star)
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.