Visual Elements

Top  Previous  Next

This is how DWQueryBuilder looks when started.

 

The main window contains the following sections:

 

The Visual Query Building Area is the main area where the visual representation of query will be displayed. This area allows you to define source database objects and derived tables, define links between them and configure properties of tables and links.

 

The Columns Pane is located below the query building area. It is used to perform all necessary operations with query output columns and expressions. Here you can define field aliases, sorting and grouping, and define criteria.

 

The Query Structure Tree Pane is located at the left. Here you may browse your query and quickly locate any part of it.
 
The Metadata Tree Pane is located at the right. Here you may browse your database tables and views and drag & drop onto the Query Building Area.

 

The Tab Control above the query building area will allow you to switch between the main query and sub-queries.

 

The 'Q' Button in the corner of the query building area with is the union sub-query handling control. Here you can add new union sub-queries and perform all necessary operations with them using popup menu.

 

The query builder displays only one query or sub-query at the moment. Each single query is shown in the Query Building Area and the Column pane.

 

Learn more:

how to build a single query
how to build a query with sub-queries
predefined layouts

 

This image shows the main visual components that you will work with in DWQueryBuilder.

Each is discussed in more detail in the sections that follow. Click on any section or on the call out to go straight to that section.

 

SQL_Structure_Panelmain