BinaryOperatorType Enum

Enumerates binary operator types.

Namespace: DevExpress.Data.Filtering

Assembly: DevExpress.Data.v23.1.dll

NuGet Package: DevExpress.Data

Declaration

C#

public enum BinaryOperatorType

VB.NET

Public Enum BinaryOperatorType

Members

Name	Description
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”)
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”)
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”)
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”)
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”)
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”)
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.
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”)
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”)
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”)
Divide	Represents the division operator. To create the division operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse(“Field1 / Field2 = 2”)
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”)
Multiply	Represents the multiplication operator. To create the multiplication operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse(“Field1 * Field2 = 100”)
Plus	Represents the addition operator. To create the addition operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse(“Field1 + Field2 = 20”)
Minus	Represents the subtraction operator. To create the subtraction operator using the CriteriaOperator.Parse method use the following syntax: CriteriaOperator.Parse(“Field1 - Field2 = 10”)

Remarks

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

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.

C#

using DevExpress.Xpo;
using DevExpress.Data.Filtering;

// Custom XP object.
class MyObject : XPObject {
   decimal unitPrice;

   public decimal UnitPrice {
      get { return unitPrice; }
      set { unitPrice = value; }
   }
   //...
}

// Select MyObject objects that match the specified criteria.
decimal filterValue = 20;
gridControl1.DataSource = new XPCollection(Session.DefaultSession, typeof(MyObject), 
  new BinaryOperator("UnitPrice", filterValue, BinaryOperatorType.GreaterOrEqual));

VB.NET

Imports DevExpress.Xpo
Imports DevExpress.Data.Filtering

' Custom XP object.
Public Class MyObject
   Inherits XPObject
   Dim _unitPrice As Decimal

   Public Property UnitPrice() As Decimal
      Get
         Return _unitPrice
      End Get
      Set(ByVal Value As Decimal)
         _unitPrice = Value
      End Set
   End Property
   '...
End Class

' Select MyObject objects that match the specified criteria.
Dim filterValue As Decimal = 20
GridControl1.DataSource = New XPCollection(Session.DefaultSession, GetType(MyObject), _
  New BinaryOperator("UnitPrice", filterValue, BinaryOperatorType.GreaterOrEqual))

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the BinaryOperatorType enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

XDL_how-to-delete-all-criteria-corresponding-to-a-particular-field-from-criteriaoperator-e3396/CS/PatchCriteriaExample/Filtering/CriteriaPatcherSkipProperties.cs#L62

if(filteredOperands.Count == 1)
    return new BinaryOperator(theOperator.LeftOperand, filteredOperands[0], BinaryOperatorType.Equal);
return new InOperator(theOperator.LeftOperand, filteredOperands);

VB.NET

XDL_how-to-delete-all-criteria-corresponding-to-a-particular-field-from-criteriaoperator-e3396/VB/PatchCriteriaExample/Filtering/CriteriaPatcherSkipProperties.vb#L88

If filteredOperands.Count = 1 Then
    Return New BinaryOperator(theOperator.LeftOperand, filteredOperands(0), BinaryOperatorType.Equal)
End If