Nested queries
If you have created a query, it will retrieve the configured data. To limit the data and make the query more specific, you can nest queries.
Procedures:
The following procedures are available for nesting queries:
-
Create another query under a query or drag and drop an existing query into another.
Advantage: The queries are created and ordered exactly as they are to be used. -
Create all queries at the same level and place them one below the other as references to nest them.
Advantage: All queries are visible at a glance and can be found and reused more easily.
Processing of nested queries:
When creating nested queries, note that the deepest query is executed first. Based on the data found in the query that was executed first, the next query is executed. This procedure is repeated until the highest and last query has been evaluated. The data found can then be output via a report component.