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.v25.2.dll

NuGet Package : DevExpress.DataAccess

csharp

public interface ISelectQueryFilterService

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.