GroupOperator Class

A logical expression which groups two or more operands with a logical AND or OR.

Namespace: DevExpress.Data.Filtering

Assembly: DevExpress.Data.v23.1.dll

NuGet Package: DevExpress.Data

Declaration

C#

public sealed class GroupOperator :
    CriteriaOperator

VB.NET

Public NotInheritable Class GroupOperator
    Inherits CriteriaOperator

Related API Members

The following members return GroupOperator objects:

• GroupOperator.Clone()

Remarks

The GroupOperator can be used to build criteria expressions when filtering objects. For more information, refer to Creating Criteria and Criteria Operators.

Tip

You can find examples in the following article: Build Criteria - Cheat Sheet.

Examples

This example retrieves the cars that belong in the Saloon category and which cost less than $100,000.

The result is shown in the image below:

C#

xpView1.GroupCriteria = GroupOperator.And(new BinaryOperator("Category", "Saloon"), 
  new BinaryOperator("Price", 100000, BinaryOperatorType.Less));

VB.NET

XPView1.GroupCriteria = GroupOperator.And(New BinaryOperator("Category", "Saloon"), _
  New BinaryOperator("Price", 100000, BinaryOperatorType.Less))

Return orders that have Price equal to 20 or OrderName equal to ‘Order3’.

Expression:

LINQ

CriteriaOperator.FromLambda<Order>(o => o.Price==20 || o.OrderName == "Order3");

Typed

var operator1 = new BinaryOperator(nameof(Order.Price), 20);
var operator2 = new BinaryOperator(nameof(Order.OrderName), "Order3");
CriteriaOperator criterion = GroupOperator.Or(operator1, operator2);

String

CriteriaOperator.Parse("Price=20 or OrderName='Order3'");

Test

Input:

OrderName	Price
Order0	10
Order1	20
Order2	30
Order3	40

The result:

OrderName
Order1
Order3

Related GitHub Examples

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

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/WindowsApplication3/CriteriaHelper.cs#L72

CriteriaOperator ICriteriaVisitor<CriteriaOperator>.Visit(GroupOperator theOperator) {
    List<CriteriaOperator> operators = new List<CriteriaOperator>();

VB.NET

XDL_how-to-delete-all-criteria-corresponding-to-a-particular-field-from-criteriaoperator-e3396/VB/WindowsApplication3/CriteriaHelper.vb#L87

Private Function ICriteriaVisitorGeneric_Visit(ByVal theOperator As GroupOperator) As CriteriaOperator Implements ICriteriaVisitor(Of CriteriaOperator).Visit
    Dim operators As New List(Of CriteriaOperator)()

Inheritance

Object

CriteriaOperator

GroupOperator