Dashboard.CustomFilterExpression Event

Allows you to include WHERE clauses into DashboardSqlDataSource queries.

Namespace: DevExpress.DashboardCommon

Assembly: DevExpress.Dashboard.v23.2.Core.dll

NuGet Package: DevExpress.Dashboard.Core

Declaration

C#

public event DashboardCustomFilterExpressionEventHandler CustomFilterExpression

VB.NET

Public Event CustomFilterExpression As DashboardCustomFilterExpressionEventHandler

Event Data

The CustomFilterExpression event's data class is DashboardCustomFilterExpressionEventArgs. 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.

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 CustomFilterExpression event is not raised for custom SQL queries and stored procedures.