Skip to main content
BuyLog In
Business Intelligence Dashboard
Search in…
Docs > Creating Dashboards > Creating Dashboards on the Web > Providing Data > Working with SQL Data Sources > Manage SQL Queries
A newer version of this page is available. .
All docs
V18.2
Dashboard
Getting Started
Basic Concepts and Terminology
Common Features
Creating the Designer and Viewer Applications
Creating Dashboards
Creating Dashboards in the WinForms Designer
Creating Dashboards on the Web
Creating a Dashboard
Providing Data
Create a New Data Source
Connect to an Existing Data Source
Manage Data Sources
Working with SQL Data Sources
Manage SQL Queries
Dashboard Data Source Wizard
Query Builder
Filter Queries
Pass Query Parameters
Custom SQL Queries
Stored Procedures
Preview Data
Filter Data Sources
Calculated Fields
OLAP Mode Limitations
Data Processing Modes
Adding Dashboard Items
Binding Dashboard Items to Data
Designing Dashboard Items
Data Shaping
Interactivity
Appearance Customization
Data Analysis
Converting Dashboard Items
Dashboard Layout
Undo and Redo Operations
Saving a Dashboard
Opening a Dashboard
Exporting
Creating Dashboards in the Visual Studio Designer
Visual Studio Integration
End-User Documentation
Localization
Redistribution and Deployment
Video Tutorials
Examples
Member Tables
.NET Framework API Reference
.NET Core API Reference
JavaScript 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 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.
  • To delete the existing query from the SQL data source, click the Delete button (the wdd-icon-delete-query icon) next to the required query.