Skip to main content
BuyLog In
Business Intelligence Dashboard
Search in…
Docs > Web Dashboard > Create Dashboards on the Web > Provide Data > Working with SQL Data Sources > Manage SQL Queries
All docs
V24.1
Business Intelligence Dashboard
Get Started
.NET Support
Basic Concepts and Terminology
Common Features
WinForms Dashboard
Web Dashboard
Prerequisites
Concepts and Terminology
Integrate the Dashboard Component into a Web App
Create Dashboards on the Web
Create a Dashboard
Provide Data
Create a New Data Source
Connect to an Existing Data Source
Manage Data Sources
Working with SQL Data Sources
Manage SQL Queries
Filter Queries
Use Query Parameters
Custom SQL Queries
Stored Procedures
Manage Timeout Limit
Filter Data Sources
Limit Visible Data
Calculated Fields
OLAP Mode Limitations
Data Processing Modes
Add Dashboard Items
Bind Dashboard Items to Data
Dashboard Item Settings
Data Shaping
Interactivity
Appearance Customization
Data Analysis
Custom Request Headers
Convert Dashboard Items
Dashboard Layout
Undo and Redo Operations
Save a Dashboard
Open a Dashboard
Delete a Dashboard
Exporting
UI Elements and Customization
Advanced Customization
WPF Dashboard Viewer
Visual Studio Integration
Redistribution and Deployment
Video Tutorials
Migration Guides
Examples
End-User Documentation
.NET Framework API Reference
.NET API Reference
HTML JS Control API Reference
ASP.NET Client API Reference
Download CHM

Manage SQL Queries

After you connect to the SQL data source, you can create a new query or edit existing queries. To manage SQL queries, open the dashboard menu and go to the Data Sources page. Select the required SQL data source and perform any required action.

wdd-data-sources-page

  • To add a new query, click the Add Query button. This action invokes the Dashboard Data Source Wizard, where you can create a query, select a stored procedure, or configure query parameters.
  • To edit the existing query, click the Edit button (the wdd-icon-edit-query icon) next to the required query. This action invokes the Dashboard Data Source Wizard where you can edit the current query.
  • To delete the existing query from the SQL data source, click the Delete button (the wdd-icon-delete-query icon) next to the query.