We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Behavior of query view in Dashboard Designer

Platform: Dashboard Platform |
Control: Dashboard Datasources

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:

  1. Cannot use ORDER BY clause inside the query view text box.
  2. Cannot use same alias name for multiple columns in the query text box.

Example: Selecting the OrderID as ID and CustomerID as ID from orders.

  1. In query view, the join editor button is in disabled state. To achieve joining operation, you can use either Inner Join or Left Outer Join directly in query itself.
  2. For query view, the data source filter is in disabled state. To achieve this, you can use where clause directly in query for filtering purpose.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile