Walkthrough: Designing the Main Query

Next, create a query to retrieve the detailed employee information using the sub-query as the selection criteria.

1. Create a query, “Above avg employees”, using the 'Personnel' data source.

2. Select the 'default' request type.

3. Using the Fields tab, select: 'name.lastname', 'name.firstname', 'location.city', 'location.state', and 'score'.

4. Click 'Finish'.

5. Select the 'employee' node and enter the following condition in the 'Condition' text area.

@id in(query('Scores',score=3))

 

Figure 6. Query Output

 

<< Walkthrough: Designing the Sub-Query © 1996-2013 InetSoft Technology Corporation (v11.5) List Comparison for Queries using Hierarchical Meta Data >>