DashboardControl.CustomFilterExpression Event

Allows you to include WHERE clauses into DashboardSqlDataSource queries.

Namespace: DevExpress.DashboardWpf

Assembly: DevExpress.Dashboard.v19.2.Wpf.dll


public event DashboardCustomFilterExpressionEventHandler CustomFilterExpression
Public Event CustomFilterExpression As DashboardCustomFilterExpressionEventHandler

Event Data

The CustomFilterExpression event handler receives an argument of the DashboardCustomFilterExpressionEventArgs type. The following properties provide information specific to this event.

Property Description
DataSource Obtains the data source that provides data for the dashboard.
(Inherited from DataSourceEventArgs)
FilterExpression Gets or sets the filter expression that defines a WHERE clause included in the SQL query.
TableName Gets the name of a data table to which the DashboardCustomFilterExpressionEventArgs.FilterExpression applies.


The CustomFilterExpression event fires for each SelectQuery within DashboardSqlDataSource (the SqlDataSource.Queries property) and allows you to include a WHERE clause to a query at runtime using the CustomFilterExpressionEventArgs.FilterExpression event parameter. If filtering is already applied to the SQL query, CustomFilterExpressionEventArgs.FilterExpression returns a corresponding filter criteria.


The CustomFilterExpression event is not raised for custom SQL queries and stored procedures.

See Also