[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Collapse]Cross-Platform Core Libraries
 [Expand]DevExpress ORM Tool
 [Expand]DevExpress Data Library
 [Expand]DevExpress Pivot Grid Core Library
 [Expand]Miscellaneous
 [Collapse]API Reference
  [Expand]DevExpress.Data
  [Expand]DevExpress.Data.Browsing
  [Expand]DevExpress.Data.Browsing.Design
  [Expand]DevExpress.Data.Camera
  [Expand]DevExpress.Data.Controls
  [Expand]DevExpress.Data.Controls.ExpressionEditor
  [Expand]DevExpress.Data.Entity
  [Expand]DevExpress.Data.Filtering
  [Expand]DevExpress.Data.Filtering.Exceptions
  [Expand]DevExpress.Data.Filtering.Helpers
  [Expand]DevExpress.Data.Linq
  [Expand]DevExpress.Data.ODataLinq
  [Expand]DevExpress.Data.PivotGrid
  [Expand]DevExpress.Data.PLinq
  [Expand]DevExpress.Data.TreeList
  [Expand]DevExpress.Data.Utils
  [Expand]DevExpress.Data.Utils.ServiceModel
  [Expand]DevExpress.Data.WcfLinq
  [Expand]DevExpress.Data.WizardFramework
  [Expand]DevExpress.Data.XtraReports.DataProviders
  [Expand]DevExpress.Data.XtraReports.Labels
  [Expand]DevExpress.Data.XtraReports.ServiceModel
  [Expand]DevExpress.Data.XtraReports.ServiceModel.DataContracts
  [Expand]DevExpress.Data.XtraReports.Wizard
  [Expand]DevExpress.Data.XtraReports.Wizard.Presenters
  [Expand]DevExpress.Data.XtraReports.Wizard.Views
  [Expand]DevExpress.DataAccess
  [Expand]DevExpress.DataAccess.ConnectionParameters
  [Expand]DevExpress.DataAccess.EntityFramework
  [Expand]DevExpress.DataAccess.Excel
  [Expand]DevExpress.DataAccess.ExpressionEditor
  [Expand]DevExpress.DataAccess.Localization
  [Expand]DevExpress.DataAccess.ObjectBinding
  [Collapse]DevExpress.DataAccess.Sql
   [Expand]AggregateQueryInvalidSortingValidationException Class
    AggregationType Enumeration
   [Expand]AggregationWithoutAliasValidationException Class
   [Expand]AliasedBase Class
   [Expand]AllColumns Class
   [Expand]CircularRelationsValidationException Class
   [Expand]Column Class
   [Expand]ColumnBase Class
   [Expand]ColumnExpression Class
   [Expand]ColumnInfo Class
   [Expand]ColumnNotInSchemaValidationException Class
   [Expand]ColumnNullValidationException Class
    ConditionType Enumeration
   [Expand]ConfigureDataConnectionEventArgs Class
    ConfigureDataConnectionEventHandler Delegate
   [Expand]ConnectionErrorEventArgs Class
    ConnectionErrorEventHandler Delegate
   [Expand]ConnectionOptions Class
   [Expand]CustomExpression Class
   [Expand]CustomExpressionWithAmbiguousColumnValidationException Class
   [Expand]CustomExpressionWithColumnOfMissingTableValidationException Class
   [Expand]CustomExpressionWithMissingInSchemaColumnValidationException Class
   [Expand]CustomizeFilterExpressionEventArgs Class
    CustomizeFilterExpressionEventHandler Delegate
   [Expand]CustomSqlQuery Class
   [Expand]CustomSqlQueryValidationException Class
   [Expand]DatabaseConnectionException Class
   [Expand]DBSchema Class
   [Expand]DBSchemaProviderEx Class
   [Expand]DuplicatingColumnNamesValidationException Class
   [Expand]DuplicatingTableNamesValidationException Class
   [Expand]ExpressionBase Class
   [Expand]ExpressionNullValidationException Class
   [Expand]ExpressionStringNullValidationException Class
   [Expand]FilterByAmbiguousColumnValidationException Class
   [Expand]FilterByColumnOfMissingTableValidationException Class
   [Expand]FilterByMissingInSchemaColumnValidationException Class
   [Expand]Group Class
   [Expand]GroupByAggregateColumnValidationException Class
   [Expand]GroupByWithoutAggregateValidationException Class
   [Expand]GroupingInfo Class
   [Expand]GroupingInfoList Class
   [Expand]GroupNullValidationException Class
   [Expand]HavingWithoutGroupByValidationException Class
   [Expand]IDBSchemaProvider Interface
   [Expand]IDBSchemaProviderEx Interface
   [Expand]IncompleteRelationValidationException Class
   [Expand]InvalidExpressionStringValidationException Class
   [Expand]IResultSchemaProvider Interface
   [Expand]Join Class
   [Expand]MasterDetailInfo Class
   [Expand]MasterDetailInfoCollection Class
   [Expand]NegativeTopSkipValidationException Class
   [Expand]NoColumnsValidationException Class
   [Expand]NoRelationColumnsValidationException Class
   [Expand]NoTablesValidationException Class
   [Expand]PartialAggregationValidationException Class
   [Expand]QueryExecutionException Class
   [Expand]QueryParameter Class
   [Expand]RecordsCount Class
   [Expand]RelationColumnInfo Class
   [Expand]RelationColumnNotInSchemaValidationException Class
   [Expand]RelationColumnNullValidationException Class
   [Expand]RelationException Class
   [Expand]RelationInfo Class
   [Expand]RelationInfoList Class
   [Expand]RelationNullValidationException Class
   [Expand]RelationTableNotSelectedValidationException Class
   [Expand]ResultSchemaProvider Class
    SchemaLoadingMode Enumeration
   [Collapse]SelectQuery Class
     SelectQuery Members
    [Expand]SelectQuery Constructor
    [Collapse]SelectQuery Properties
      Columns Property
      Distinct Property
      FilterString Property
      GroupFilterString Property
      Groups Property
      Relations Property
      Skip Property
      Sorting Property
      Tables Property
      Top Property
    [Expand]SelectQuery Methods
   [Expand]SelectQueryFluentBuilder Class
   [Expand]SkipWithoutSortingValidationException Class
   [Expand]SortByAggregateColumnValidationException Class
   [Expand]Sorting Class
   [Expand]SortingBySameColumnTwiceValidationException Class
   [Expand]SortingInfo Class
   [Expand]SortingInfoList Class
   [Expand]SortingNullValidationException Class
   [Expand]SqlDataConnection Class
   [Expand]SqlDataSource Class
   [Expand]SqlQuery Class
   [Expand]SqlQueryCollection Class
   [Expand]SqlStringEmptyValidationException Class
   [Expand]StoredProcNameNullValidationException Class
   [Expand]StoredProcNotInSchemaValidationException Class
   [Expand]StoredProcParamCountValidationException Class
   [Expand]StoredProcParamNameValidationException Class
   [Expand]StoredProcParamNullValidationException Class
   [Expand]StoredProcParamTypeValidationException Class
   [Expand]StoredProcQuery Class
   [Expand]Table Class
   [Expand]TableInfo Class
   [Expand]TableInfoList Class
   [Expand]TableNotInSchemaValidationException Class
   [Expand]TableNotSelectedValidationException Class
   [Expand]TableNullValidationException Class
   [Expand]TableQuery Class
   [Expand]TablesNotRelatedValidationException Class
   [Expand]UnnamedColumnValidationException Class
   [Expand]UnnamedTableValidationException Class
   [Expand]ValidationException Class
  [Expand]DevExpress.DataAccess.Sql.DataApi
  [Expand]DevExpress.DataAccess.UI
  [Expand]DevExpress.DataAccess.UI.Design
  [Expand]DevExpress.DataAccess.UI.EntityFramework
  [Expand]DevExpress.DataAccess.UI.Excel
  [Expand]DevExpress.DataAccess.UI.Localization
  [Expand]DevExpress.DataAccess.UI.ObjectBinding
  [Expand]DevExpress.DataAccess.UI.Sql
  [Expand]DevExpress.DataAccess.UI.Wizard
  [Expand]DevExpress.DataAccess.UI.Wizard.Services
  [Expand]DevExpress.DataAccess.UI.Wizard.Views
  [Expand]DevExpress.DataAccess.Web
  [Expand]DevExpress.DataAccess.Wizard
  [Expand]DevExpress.DataAccess.Wizard.Model
  [Expand]DevExpress.DataAccess.Wizard.Presenters
  [Expand]DevExpress.DataAccess.Wizard.Services
  [Expand]DevExpress.DataAccess.Wizard.Views
  [Expand]DevExpress.Diagram.Core
  [Expand]DevExpress.Diagram.Core.Layout
  [Expand]DevExpress.Diagram.Core.Localization
  [Expand]DevExpress.Diagram.Core.Shapes
  [Expand]DevExpress.Diagram.Core.Themes
  [Expand]DevExpress.DocumentServices.ServiceModel
  [Expand]DevExpress.DocumentServices.ServiceModel.Client
  [Expand]DevExpress.DocumentServices.ServiceModel.DataContracts
  [Expand]DevExpress.DocumentView
  [Expand]DevExpress.Entity.Model
  [Expand]DevExpress.Entity.ProjectModel
  [Expand]DevExpress.Export
  [Expand]DevExpress.Export.Xl
  [Expand]DevExpress.Map
  [Expand]DevExpress.Mvvm
  [Expand]DevExpress.Mvvm.DataAnnotations
  [Expand]DevExpress.Mvvm.DataModel
  [Expand]DevExpress.Mvvm.ModuleInjection
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.Utils
  [Expand]DevExpress.Mvvm.ViewModel
  [Expand]DevExpress.Office
  [Expand]DevExpress.Office.Crypto
  [Expand]DevExpress.Office.Drawing
  [Expand]DevExpress.Office.Export
  [Expand]DevExpress.Office.Export.Html
  [Expand]DevExpress.Office.Import
  [Expand]DevExpress.Office.Localization
  [Expand]DevExpress.Office.Options
  [Expand]DevExpress.Office.Services
  [Expand]DevExpress.Office.Utils
  [Expand]DevExpress.Pdf
  [Expand]DevExpress.Pdf.Localization
  [Expand]DevExpress.PivotGrid.Printing
  [Expand]DevExpress.Printing
  [Expand]DevExpress.Printing.Core
  [Expand]DevExpress.Printing.ExportHelpers
  [Expand]DevExpress.ReportServer.Printing
  [Expand]DevExpress.ReportServer.Printing.Services
  [Expand]DevExpress.ReportServer.ServiceModel.Client
  [Expand]DevExpress.ReportServer.ServiceModel.ConnectionProviders
  [Expand]DevExpress.ReportServer.ServiceModel.DataContracts
  [Expand]DevExpress.Schedule
  [Expand]DevExpress.Services
  [Expand]DevExpress.Sparkline
  [Expand]DevExpress.Spreadsheet
  [Expand]DevExpress.Spreadsheet.Charts
  [Expand]DevExpress.Spreadsheet.Drawings
  [Expand]DevExpress.Spreadsheet.Export
  [Expand]DevExpress.Spreadsheet.Formulas
  [Expand]DevExpress.Spreadsheet.Functions
  [Expand]DevExpress.TreeMap
  [Expand]DevExpress.Utils
  [Expand]DevExpress.Utils.Commands
  [Expand]DevExpress.Utils.Controls
  [Expand]DevExpress.Utils.Filtering.Internal
  [Expand]DevExpress.Utils.IoC
  [Expand]DevExpress.Utils.Localization
  [Expand]DevExpress.Utils.Serializing.Helpers
  [Expand]DevExpress.WebUtils
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpo
  [Expand]DevExpress.Xpo.DB
  [Expand]DevExpress.Xpo.DB.Exceptions
  [Expand]DevExpress.Xpo.DB.Helpers
  [Expand]DevExpress.Xpo.Exceptions
  [Expand]DevExpress.Xpo.Helpers
  [Expand]DevExpress.Xpo.Metadata
  [Expand]DevExpress.XtraCharts
  [Expand]DevExpress.XtraCharts.Localization
  [Expand]DevExpress.XtraCharts.Printing
  [Expand]DevExpress.XtraEditors
  [Expand]DevExpress.XtraEditors.DXErrorProvider
  [Expand]DevExpress.XtraExport.Csv
  [Expand]DevExpress.XtraGauges.Base
  [Expand]DevExpress.XtraGauges.Core
  [Expand]DevExpress.XtraGauges.Core.Base
  [Expand]DevExpress.XtraGauges.Core.Drawing
  [Expand]DevExpress.XtraGauges.Core.Localization
  [Expand]DevExpress.XtraGauges.Core.Model
  [Expand]DevExpress.XtraGauges.Core.Primitive
  [Expand]DevExpress.XtraGrid
  [Expand]DevExpress.XtraPivotGrid
  [Expand]DevExpress.XtraPivotGrid.Customization
  [Expand]DevExpress.XtraPivotGrid.Data
  [Expand]DevExpress.XtraPivotGrid.Localization
  [Expand]DevExpress.XtraPivotGrid.Selection
  [Expand]DevExpress.XtraPrinting
  [Expand]DevExpress.XtraPrinting.BarCode
  [Expand]DevExpress.XtraPrinting.Caching
  [Expand]DevExpress.XtraPrinting.DataNodes
  [Expand]DevExpress.XtraPrinting.Drawing
  [Expand]DevExpress.XtraPrinting.Export
  [Expand]DevExpress.XtraPrinting.Export.Web
  [Expand]DevExpress.XtraPrinting.Localization
  [Expand]DevExpress.XtraPrinting.Native
  [Expand]DevExpress.XtraPrinting.Shape
  [Expand]DevExpress.XtraPrinting.Shape.Native
  [Expand]DevExpress.XtraPrinting.WebClientUIControl.DataContracts
  [Expand]DevExpress.XtraPrinting.XamlExport
  [Expand]DevExpress.XtraPrintingLinks
  [Expand]DevExpress.XtraReports
  [Expand]DevExpress.XtraReports.Design
  [Expand]DevExpress.XtraReports.Parameters
  [Expand]DevExpress.XtraReports.ReportGeneration
  [Expand]DevExpress.XtraReports.UI
  [Expand]DevExpress.XtraRichEdit
  [Expand]DevExpress.XtraRichEdit.API.Layout
  [Expand]DevExpress.XtraRichEdit.API.Native
  [Expand]DevExpress.XtraRichEdit.API.Native.Implementation
  [Expand]DevExpress.XtraRichEdit.Commands
  [Expand]DevExpress.XtraRichEdit.Export
  [Expand]DevExpress.XtraRichEdit.Export.Html
  [Expand]DevExpress.XtraRichEdit.Export.Rtf
  [Expand]DevExpress.XtraRichEdit.Forms
  [Expand]DevExpress.XtraRichEdit.Import
  [Expand]DevExpress.XtraRichEdit.Localization
  [Expand]DevExpress.XtraRichEdit.Services
  [Expand]DevExpress.XtraRichEdit.Utils
  [Expand]DevExpress.XtraScheduler
  [Expand]DevExpress.XtraScheduler.Compatibility
  [Expand]DevExpress.XtraScheduler.Drawing
  [Expand]DevExpress.XtraScheduler.Exchange
  [Expand]DevExpress.XtraScheduler.iCalendar
  [Expand]DevExpress.XtraScheduler.iCalendar.Components
  [Expand]DevExpress.XtraScheduler.Localization
  [Expand]DevExpress.XtraScheduler.Native
  [Expand]DevExpress.XtraScheduler.Outlook
  [Expand]DevExpress.XtraScheduler.Outlook.Interop
  [Expand]DevExpress.XtraScheduler.Reporting
  [Expand]DevExpress.XtraScheduler.Services
  [Expand]DevExpress.XtraScheduler.Services.Implementation
  [Expand]DevExpress.XtraScheduler.Tools
  [Expand]DevExpress.XtraScheduler.UI
  [Expand]DevExpress.XtraScheduler.Xml
  [Expand]DevExpress.XtraSpellChecker
  [Expand]DevExpress.XtraSpreadsheet
  [Expand]DevExpress.XtraSpreadsheet.Export
  [Expand]DevExpress.XtraSpreadsheet.Export.Html
  [Expand]DevExpress.XtraSpreadsheet.Import
  [Expand]DevExpress.XtraSpreadsheet.Localization
  [Expand]DevExpress.XtraSpreadsheet.Services
[Expand]Tools and Utilities
 End-User Documentation

SelectQuery.FilterString Property

Specifies the criteria used to filter data returned by the current SelectQuery.

Namespace:DevExpress.DataAccess.Sql
Assembly:DevExpress.DataAccess.v18.1.dll

Expanded Syntax

Property value

Type: String
A System.String value, specifying the filter criteria.
The default is null.

Expanded Remarks

The FilterString property allows you to filter the result set returned by SelectQuery by specifying the required filter criteria. To filter a SelectQuery by specified column values, precede a column name with a corresponding table name. For instance, you can filter the SalesPerson table by the Beverages category in the following way.

To pass a QueryParameter (which can be accessed using the SqlQuery.Parameters property) to the filter string, precede the parameter name with the ? sign.

To learn more about building filter criteria, see Creating Criteria.

Expanded See Also

Is this topic helpful?​​​​​​​