Connected Query Example

This example shows the structure that Connected Query uses to collect data of each employee, who directly and indirectly reports to specific departments.

In this example:

• The first query (QE_DEPARTMENTS_ROLLUP_PERS) selects a list of departments that report to a specific department defined by user in the first query prompt.

• The second query (QE_EMPLOYEE_FROM_PERSDATA_TREE) selects lists of employee based on the departments returned from the parent query.

  Query QE_EMPLOYEE displays detailed information of every employee that is selected by query QE_EMPLOYEE_FROM_PERSDATA_TREE.

• The last query (QE_DEPARTMENT_DATA) displays detailed information of each department that participated in the report.