Query to get the Highest level(One below CEO) of Manager for an employee — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query to get the Highest level(One below CEO) of Manager for an employee

edited Apr 13, 2020 7:48AM in Human Capital Management 3 comments

Summary

Query to get the Highest level(One below CEO) of Manager for an employee

Content

Hi Team

We have our requirement where we need to fetch the highest level of Manager (who is the direct report of CEO) for an Employee. Please find below the detailed scenario

1. Employee 1 > Manager A > Manager B > Manager C > Manager D > CEO

2. Employee 2 > Manager  F > Manager G > Manager H > CEO

We would need to fetch the Manager D and Manager H, when we pass the person number of Employee 1 and Employee 2 respectively as parameter.

Kindly share the sample query where we can fetch the highest level of Manager who is just reporting to CEO for any employee.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!