I have created a view that extracts data from an Oracle database. Each
employee record has the supervisor_name and unique supervisor ID. The view
orders the data in a way that the managers are entered before the
employees. This way the managers can be referenced.
Unfortunately, IDM forces an ORDER BY PK_Employee_Number which overides my
order sequence. So, my question is how do you automatically build an
organizational chart if you have more than 1000 employees and you can't
control the way data is entered into IDM?
Thanks in advance