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:
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.
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.
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.
At top-right side of the DataGrid, It's possible make a quick search of the displayed results.
In this section: