Skip to main content
All docs
V24.1

ISelectQueryFilterService.CustomizeFilterExpression(SelectQuery, CriteriaOperator) Method

Allows you to add a conditional clause to each SELECT query before the SqlDataSource executes it.

Namespace: DevExpress.DataAccess.Web

Assembly: DevExpress.DataAccess.v24.1.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

CriteriaOperator CustomizeFilterExpression(
    SelectQuery query,
    CriteriaOperator filterExpression
)

Parameters

Name Type Description
query SelectQuery

A SELECT query.

filterExpression CriteriaOperator

A filter already applied to the SELECT query.

Returns

Type Description
CriteriaOperator

A filter that should be applied to the SELECT query.

Remarks

The CustomizeFilterExpression method allows you to add a conditional clause to each SELECT query before execution. You can change the query filter, but you cannot modify the original query passed as the method’s parameter.

For a code example, refer to the following help topic: Multi-Tenant Support (Row Filtering in Shared SQL Database).

See Also