ISelectQueryFilterService Interface

A service that allows you to apply row-level filtering to all SELECT queries for the Document Viewer, Report Designer Preview, and Query Builder components.

Namespace: DevExpress.DataAccess.Web

Assembly: DevExpress.DataAccess.v23.2.dll

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

Declaration

C#

public interface ISelectQueryFilterService

VB.NET

Public Interface ISelectQueryFilterService

Remarks

The Document Viewer, Report Designer’s Preview, and Query Builder call the ISelectQueryFilterService service before the SqlDataSource executes a SELECT query. Use the CustomizeFilterExpression method to add a conditional clause to each query before it is executed.

For more information, review the following help topic: Multi-Tenant Support (Row Filtering in Shared SQL Database).

Limitations

• The ISelectQueryFilterService is not invoked for custom queries. A custom query is the CustomSqlQuery object created when the SqlWizardOptions.EnableCustomSql parameter is set to true.