DashboardControl.CustomFilterExpression Event
Allows you to include WHERE clauses into DashboardSqlDataSource queries.
Namespace: DevExpress.DashboardWpf
Assembly: DevExpress.Dashboard.v24.2.Wpf.dll
NuGet Package: DevExpress.Wpf.Dashboard
#Declaration
public event DashboardCustomFilterExpressionEventHandler CustomFilterExpression
#Event Data
The CustomFilterExpression event's data class is DashboardCustomFilterExpressionEventArgs. The following properties provide information specific to this event:
Property | Description |
---|---|
Data |
Obtains the data source that provides data for the dashboard.
Inherited from Data |
Filter |
Gets or sets the filter expression that defines a WHERE clause included in the SQL query. |
#Remarks
The CustomFilterExpression
event fires for each SelectQuery within the SqlDataSource.Queries collection. The e.FilterExpression property allows you to include a WHERE clause into a query at runtime. If a filter is already applied to the SQL query, e.FilterExpression
returns the corresponding filter criteria.
For more information on how to create filter criteria as a CriteriaOperator object, refer to the following help article: Simplified Criteria Syntax.
Note
The Custom