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).