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 >> |