| Showing Supervisor Hierarchy in Discoverer [message #126877] |
Thu, 07 July 2005 01:46 |
rrupa_p
Messages: 1
Registered: July 2005
Location: Mumbai
|
Junior Member |
|
|
Hi,
I am trying to display the details of the employees immediate supervisor and supervisors supervisor and so on.. i.e.
Employee ->(reports to)-> Supervisor ->(reports to)-> Supervisor1 ->(reports to)-> Supervisor2 ...
I am getting the data using the foll sql:
SELECT DISTINCT LEVEL
, PAPF.full_name emp_name
, PAPF.employee_number supervisor_wwid
, PAPF1.full_name supervisor_name
FROM per_all_people_f PAPF
, per_all_people_f PAPF1
, per_all_assignments_f PAAF
WHERE PAPF.person_id = PAAF.person_id
AND PAAF.supervisor_id = PAPF1.person_id
AND SYSDATE BETWEEN PAPF.effective_start_date
AND PAPF.effective_end_date
AND SYSDATE BETWEEN PAPF1.effective_start_date
AND PAPF1.effective_end_date
AND SYSDATE BETWEEN PAAF.effective_start_date
AND PAAF.effective_end_date
START WITH PAAF.person_id = PAAF.person_id
CONNECT BY PRIOR PAAF.supervisor_id = PAAF.person_id
ORDER BY LEVEL
But i am not able to do the same in discoverer. I am passing the person_id of a employee and need to pick his supervisor hierarchy. But when i do this it picks the data for that person only.. it does not pick the supervisors supervisor record.
Would appreciate if anybody could let me know is it possible to achieve such a layout using discoverer.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
