[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]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Collapse]Cross-Platform Core Libraries
 [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
  [Collapse]DevExpress.Data.Filtering
    Aggregate Enumeration
   [Expand]AggregateOperand Class
   [Expand]BaseNodeEventArgs Class
   [Expand]BetweenOperator Class
   [Expand]BinaryOperator Class
    BinaryOperatorType Enumeration
   [Expand]ConstantValue Class
   [Expand]ContainsOperator Class
   [Expand]CriteriaOperator Class
   [Expand]CriteriaOperatorCollection Class
   [Expand]EnumProcessingHelper Class
    FilterCondition Enumeration
    FindPanelParserKind Enumeration
    FunctionCategory Enumeration
   [Expand]FunctionOperator Class
    FunctionOperatorType Enumeration
   [Expand]GroupOperator Class
    GroupOperatorType Enumeration
   [Expand]IClientCriteriaVisitor Interface
   [Expand]ICriteriaVisitor Interface
   [Expand]ICustomFunctionOperator Interface
   [Expand]ICustomFunctionOperatorBrowsable Interface
   [Expand]ICustomFunctionOperatorCompileable Interface
   [Expand]ICustomFunctionOperatorCompileableWithCaseSensitivity Interface
   [Expand]ICustomFunctionOperatorConvertibleToExpression Interface
   [Expand]ICustomFunctionOperatorEvaluatableWithCaseSensitivity Interface
   [Expand]ICustomFunctionOperatorFormattable Interface
   [Expand]InOperator Class
   [Expand]JoinOperand Class
   [Expand]NotOperator Class
   [Expand]NullOperator Class
   [Expand]OperandParameter Class
   [Expand]OperandProperty Class
   [Expand]OperandValue Class
   [Expand]UnaryOperator Class
    UnaryOperatorType Enumeration
  [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.DataFederation
  [Expand]DevExpress.DataAccess.EntityFramework
  [Expand]DevExpress.DataAccess.Excel
  [Expand]DevExpress.DataAccess.ExpressionEditor
  [Expand]DevExpress.DataAccess.Json
  [Expand]DevExpress.DataAccess.Localization
  [Expand]DevExpress.DataAccess.ObjectBinding
  [Expand]DevExpress.DataAccess.Sql
  [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.Gantt
  [Expand]DevExpress.Mvvm.ModuleInjection
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.Utils
  [Expand]DevExpress.Mvvm.ViewModel
  [Expand]DevExpress.Office.Crypto
  [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.Security.Resources
  [Expand]DevExpress.Services
  [Expand]DevExpress.Sparkline
  [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.Utils.Svg
  [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.Helpers
  [Expand]DevExpress.XtraCharts
  [Expand]DevExpress.XtraCharts.Localization
  [Expand]DevExpress.XtraCharts.Native
  [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.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.XtraSpellChecker.Rules
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

BinaryOperatorType Enumeration

Enumerates binary operator types.

Namespace:DevExpress.Data.Filtering
Assembly:DevExpress.Data.v19.1.dll

Expanded Public Members

Show: Inherited
  Name Description
Public field BitwiseAnd

Represents the bitwise AND operator.

To create the bitwise AND operator using the CriteriaOperator.Parse method use the following syntax:

CriteriaOperator.Parse("Field1 & 128 = 128")

Public field BitwiseOr

Represents the bitwise OR operator.

To create the bitwise OR operator using the CriteriaOperator.Parse method use the following syntax:

CriteriaOperator.Parse("Field1 | 3")

Public field BitwiseXor

Represents the bitwise XOR operator.

To create the bitwise XOR operator using the CriteriaOperator.Parse method use the following syntax:

CriteriaOperator.Parse("(Field1 ^ Field2) = 1")

Public field Divide

Represents the division operator.

To create the division operator using the CriteriaOperator.Parse method use the following syntax:

CriteriaOperator.Parse("Field1 / Field2 = 2")

Public field Equal

Represents the Boolean equality operator.

To create the Boolean equality operator using the CriteriaOperator.Parse method use the following syntax:

CriteriaOperator.Parse("Field1 = Field2")

Public field Greater

Represents the Boolean greater-than operator.

To create the Boolean greater-than operator using the CriteriaOperator.Parse method use the following syntax:

CriteriaOperator.Parse("Field1 > Field2")

Public field GreaterOrEqual

Represents the Boolean greater-than-or-equal-to operator.

To create the Boolean greater-than-or-equal-to operator using the CriteriaOperator.Parse method use the following syntax:

CriteriaOperator.Parse("Field1 >= Field2")

Public field Less

Represents the Boolean less-than operator.

To create the Boolean less-than operator using the CriteriaOperator.Parse method use the following syntax:

CriteriaOperator.Parse("Field1 < Field2")

Public field LessOrEqual

Represents the Boolean less-than-or-equal-to operator.

To create the Boolean less-than-or-equal-to operator using the CriteriaOperator.Parse method use the following syntax:

CriteriaOperator.Parse("Field1 <= Field2")

Public field Like Obsolete. The LIKE operator. This operator behavior is different, depending on current circumstances. We recommend that you use StartsWith, Contains and EndsWith function operators instead of Like, where possible.
Public field Minus

Represents the subtraction operator.

To create the subtraction operator using the CriteriaOperator.Parse method use the following syntax:

CriteriaOperator.Parse("Field1 - Field2 = 10")

Public field Modulo

Represents the modulus operator (computes the remainder after dividing its first operand by its second).

To create the modulus operator using the CriteriaOperator.Parse method use the following syntax:

CriteriaOperator.Parse("Field1 % Field2 = 1")

Public field Multiply

Represents the multiplication operator.

To create the multiplication operator using the CriteriaOperator.Parse method use the following syntax:

CriteriaOperator.Parse("Field1 * Field2 = 100")

Public field NotEqual

Represents the Boolean inequality operator.

To create the Boolean inequality operator using the CriteriaOperator.Parse method use the following syntax:

CriteriaOperator.Parse("Field1 != Field2") or CriteriaOperator.Parse("Field1 <> Field2")

Public field Plus

Represents the addition operator.

To create the addition operator using the CriteriaOperator.Parse method use the following syntax:

CriteriaOperator.Parse("Field1 + Field2 = 20")

Top

Expanded Remarks

This enumeration contains binary operator types that can be used to create filter criteria via the BinaryOperator objects.

Expanded Example

The following code demonstrates how to get a collection of "MyObject" objects that match specific criteria. The collection returned is used as a data source for a grid control. In this example, objects that have a value equal to or greater than 20 in their "UnitPrice" field are returned. To create the filter criteria a specific BinaryOperator operator is used.

Expanded See Also

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