In QueryBuilder, it is also possible to use already existing queries, in order to create new queries building on them.
The existing query is called the base query, the new query is called
successor query. The idea is that the output result is used by the base
query as input to a subsequent query.
To use this functionality, a query from the selection box base query must be chosen first. Select then for the selected query a column in the selection box column for the base query, which is then used as input for the successor query.
In the list of queries, the base query is displayed as superordinate to the successor query.
Only queries of the same class can be used as a base queries. If you change the class of the base query, the class of the successor query is also changed. If you delete the base query, all successor queries are deleted. Functions like Copy / Copy special and Paste / Paste special are available for queries. If you select Copy special for the base query, successor queries can also be copied.
You will be able to understand the procedure more, if you consider the
In the demo database a new query Query1 is created, which should display all objects of the Unit 2.1. Enterprise Architecture of the classes Process and Application, which are connected to these objects through the link type “link with the following processes”.
This query will be used as a basis for the new query Query2. The entry
name is chosen in Query2 in the selection box base query Query1 and
in the selection box column for the base query.
After this selection, the entry name and e.g. the name of the diagrams are selected, which use the object. If you click run query now, then the objects of the first column from the Unit 2.1 Enterprise Architecture and from the classes Process and Application *appear with the link type ”linked with the following processes”* (this information is taken from the Query1). The second column shows the names of the diagram, where the objects are used.