The Query Builder window has 2 parts:
The Query tab enables you to build and run an SQL query on selected DB Tables and is divided into the following working areas:
Displays the data received from the executed query. Click on Export to Excel to export the data into an Excel file.
When opened via the DB Interface Explorer, the Query Builder opens in the main panel, on the right.
When opened from either the Schema Editor, Graphit or Broadway - the Query Builder opens as a popup window:
You can control the sizes of the Query Editor and the Results windows: Hover your mouse cursor over the horizontal separating line, which appears between these parts, and you will see the ellipsis indication; your cursor type will turn to be a cursor-resize . Use it to resize the windows' heights.
You can edit the SQL commands in the Query Editor panel - the upper part of the Query Builder window.
It contains the editing area and top action bar, where you can run your query by clicking on the Execute button or clear the editing area by clicking on the Clear button.
Note: You can open Query Builder where Fabric is the data source. In such case, several fields will be shown in the top bar of the Query Editor panel: Sync mode, Select LU, Instance ID. Set these fields before executing the query.
When executing the query, the results are presented in a table view in the Results window (bottom part).
The Results window shows up to 1000 entries.
The Results window's top bar is divided into 2 parts: information (on the right side) and actions (on the left side):
The Results table enables some manipulations that let you adjust the display according to your needs, in addition to the Columns to show option:
Sort Order - click on the column's header sort icon ![sort](C:\Users\EyalOrbach\OneDrive - K2View\K2View-Academy-7.2\articles\11_query_builder\images\web\order_icon.png) to reorder the table (Ascending/Descending).
Filter - click on the column's header filter icon ![sort](C:\Users\EyalOrbach\OneDrive - K2View\K2View-Academy-7.2\articles\11_query_builder\images\web\filter_icon.png)to filter table's display accordingly.
Group - click on the column's header left arrow to group the table rows by this column.
Grouping by a column will show it as the left most column, change its color to gray and flip the arrow direction.
Click on a table row arrow to expand and collapse its grouped rows.
You can group by several columns.
To ungroup, click again on the column header arrow.
![grouping](C:\Users\EyalOrbach\OneDrive - K2View\K2View-Academy-7.2\articles\11_query_builder\images\web\01_results_grouping.png)
The Query Builder window has 2 parts:
The Query tab enables you to build and run an SQL query on selected DB Tables and is divided into the following working areas:
Displays the data received from the executed query. Click on Export to Excel to export the data into an Excel file.
When opened via the DB Interface Explorer, the Query Builder opens in the main panel, on the right.
When opened from either the Schema Editor, Graphit or Broadway - the Query Builder opens as a popup window:
You can control the sizes of the Query Editor and the Results windows: Hover your mouse cursor over the horizontal separating line, which appears between these parts, and you will see the ellipsis indication; your cursor type will turn to be a cursor-resize . Use it to resize the windows' heights.
You can edit the SQL commands in the Query Editor panel - the upper part of the Query Builder window.
It contains the editing area and top action bar, where you can run your query by clicking on the Execute button or clear the editing area by clicking on the Clear button.
Note: You can open Query Builder where Fabric is the data source. In such case, several fields will be shown in the top bar of the Query Editor panel: Sync mode, Select LU, Instance ID. Set these fields before executing the query.
When executing the query, the results are presented in a table view in the Results window (bottom part).
The Results window shows up to 1000 entries.
The Results window's top bar is divided into 2 parts: information (on the right side) and actions (on the left side):
The Results table enables some manipulations that let you adjust the display according to your needs, in addition to the Columns to show option:
Sort Order - click on the column's header sort icon ![sort](C:\Users\EyalOrbach\OneDrive - K2View\K2View-Academy-7.2\articles\11_query_builder\images\web\order_icon.png) to reorder the table (Ascending/Descending).
Filter - click on the column's header filter icon ![sort](C:\Users\EyalOrbach\OneDrive - K2View\K2View-Academy-7.2\articles\11_query_builder\images\web\filter_icon.png)to filter table's display accordingly.
Group - click on the column's header left arrow to group the table rows by this column.
Grouping by a column will show it as the left most column, change its color to gray and flip the arrow direction.
Click on a table row arrow to expand and collapse its grouped rows.
You can group by several columns.
To ungroup, click again on the column header arrow.
![grouping](C:\Users\EyalOrbach\OneDrive - K2View\K2View-Academy-7.2\articles\11_query_builder\images\web\01_results_grouping.png)