Skip to main content
BuyLog In
Business Intelligence Dashboard
Search in…
Docs > Create Dashboards > Create Dashboards on the Web > Providing Data > Working with SQL Data Sources > Filter Queries
A newer version of this page is available. .
All docs
V19.1
Dashboard
Get Started
Basic Concepts and Terminology
Common Features
Create the Designer and Viewer Applications
Create Dashboards
Create Dashboards in the WinForms Designer
Create Dashboards on the Web
Create 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 Items Layout
Undo and Redo Operations
Saving a Dashboard
Opening a Dashboard
Exporting
Create Dashboards in the Visual Studio Designer
Visual Studio Integration
End-User Documentation
Localization
Redistribution and Deployment
Video Tutorials
Migration Guides
Examples
Member Tables
.NET Framework API Reference
.NET Core API Reference
HTML JS Control API Reference
ASP.NET Client API Reference
Download CHM

Filter Queries

SQL queries constructed in the Query Builder can be filtered by including the WHERE clauses in the query. Filtering can be applied to underlying or aggregated data.

To filter a query, deselect added tables and click the ellipsis button next to the Filter field in the Query Builder.

wdd-invoke-filter-editor-for-query

This invokes the Filter Editor dialog which allows you to build filter criteria.

wdd-filter-editor-filter-query

See Filtering to learn how to use this dialog.

The Filter Editor enables you to compare field values with the following objects:

  • Value - Allows you to compare field and static values.
  • Property - Compares different field values.

  • Parameter - Allows you to compare field and query parameter values. You can choose an existing query parameter or create a new one by selecting Create new parameter.

    SqlFiltering_FilterEditor_ParameterDropdown

Note

The Group Filter option from Query Properties allows you to apply filtering to grouped/aggregated data fields by including HAVING clauses in the query. The Group By and Aggregate options in the Query Builder manage Grouping and aggregation.See the Edit Column Settings paragraph in the Query Builder topic for more information.