Dashboard.CustomFilterExpression Event

Allows you to include WHERE clauses into DashboardSqlDataSource queries.

Namespace: DevExpress.DashboardCommon

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

Declaration

public event DashboardCustomFilterExpressionEventHandler CustomFilterExpression
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.
TableName Gets the name of a data table to which the DashboardCustomFilterExpressionEventArgs.FilterExpression applies.

Remarks

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.

NOTE

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

See Also