Skip to main content
All docs
V25.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.v25.1.dll

    NuGet Package: DevExpress.DataAccess

    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