In Syncfusion Dashboard Designer, users can execute their own query for server type connections such as SQL, MySQL, PostgreSQL, Oracle, and ODBC ANSI SQL. For this, click the Query View option in the Data Design window.
In the query text box, users can enter the respective query and click Execute to run the query for result.
After the query is executed and results are obtained, users will proceed designing their dashboard on top of it. During those scenarios, if you perform any operations like widget configuration, filter interaction, and sorting, the resultant query will be framed as same as adding the master query (query executed inside the query view) as sub query.
For example, if you bind the CustomerID column in the grid control, the Syncfusion Dashboard Designer generates query as follows.
SELECT TOP 200 [CustomerID] AS [Grid_Column_0] FROM (select * from Orders)"DashboardSelectSubQuery" GROUP BY [CustomerID] ORDER BY 1 ASC
Here, the provided master query "select * from Orders" in the query view text box will be added into the sub query to generate the correct result, since users design their dashboard on top of the master query.
Due to this behavior, the following limitations may occur in the query:
Example: Selecting the OrderID as ID and CustomerID as ID from orders.
This page will automatically be redirected to the sign-in page in 10 seconds.