Query Builder

Visual query builder can help you design your queries without typing SQL code. Query Builder is available at the Builder view of a query.

Query builder consists of four panes:

Result Fields pane. This pane is the topmost pane. You can drag tables and columns from the Connection Object List to this pane to query their data (add them to the SELECT and FROM clauses of the SELECT statement). Read more...

Filters pane. This pane is located under the Result Fields pane. You can drag columns from the Connection Object List to this pane to filter data by these columns (add them to the WHERE clause of the query). Read more...

Sort Fields pane. This pane is located under the Filters pane. You can drag columns from the Connection Object List or from the Result Fields pane to this pane in order to sort the queried data by these columns (add them to the ORDER BY clause of the query). Read more...

Details pane. This pane is located to the right of other three panes. It allows you to configure query in more details and displays settings for the currently selected item in one of other panes. When you select an item on the Result Fields pane, the Details pane allows you to apply functions to the result fields. For an item on the Filters pane, the Details pane allows configuring the filter, and for an item on the Sort Fields pane it allows you to change the sorting order. For more details read the corresponding topics in the  section.