Dashboard for Desktop > Dashboard Designer > Working with Data > Query Editor
The Query Editor dialog allows you to create new SQL queries or edit the existing queries created using the Data Source wizard. Optionally, you can add query parameters.
The Query Editor can contain two pages depending on the current query.
1.The first page allows you to specify the query or select the stored procedure.
You can choose the following options to create/modify a query.
oSelect the Query option and run the Query Builder by clicking the Run Query Builder... button. The Query Builder allows you to choose the required tables/columns visually and displays the resulting SQL query within the SQL String editor.
oIf available, select the Stored Procedure option to select one of the stored procedures from the database.
2.The second page of the Query Editor allows you to add or modify query parameters.
Copyright (c) 1998-2016 Developer Express Inc. All rights reserved.
Send Feedback on this topic to DevExpress.