Overview
This tool allows you to test existing queries used by the solution or even create new ones.
It's also used to preview the results, and to customize the right DataGrid settings for visualization.
On this page:
User Interface
Database Selection
This section provides options to select the target database for query execution.
Users can choose between a database used in the solution or establish a custom database connection.
It is not necessary to execute any Connect command. Once the Query is executed, the connection with the Database is automatically executed.
Query Input and Execution
This code editor area where users can write or paste their SQL queries.
A dropdown menu offers a selection from predefined datasets or queries. Write the SQL query (or use the arrow icon to bring from the solution) and press 'Execute Query' for start.
Results DataGrid
Display the outcome of the executed query. It includes functionality to group results by dragging and dropping column headers, and most of features described in the page Working with DataGrids.
Results search
At top-right side of the DataGrid, It's possible make a quick search of the displayed results.
In this section: