InOperator Class

An operator which determines if a value matches any value in a specified list.

Namespace: DevExpress.Data.Filtering

Assembly: DevExpress.Data.v23.1.dll

NuGet Package: DevExpress.Data

Declaration

C#

public class InOperator :
    CriteriaOperator

VB.NET

Public Class InOperator
    Inherits CriteriaOperator

Related API Members

The following members return InOperator objects:

• InOperator.Clone()

Remarks

The InOperator builds criteria expressions. To learn more, see Creating Criteria and Criteria Operators.

In this example, the XPCollection is filtered to display persons whose names are specified in the list.

C#

xpCollection1.Filter = new InOperator("Name", new string[] {"John", "Mike", "Nick"});

VB.NET

XPCollection1.Filter = New InOperator("Name", New String() {"John", "Mike", "Nick"})

The image below shows the result:

Note

You cannot apply InOperator to collection properties. To check if a collection contains at least one object that matches a specific criterion, use the ContainsOperator instead.

Tip

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

Example

Get order with the OrderName property ore one of the follows values: ‘Order2’, ‘Order3’,’Description5’.

Expression:

LINQ

CriteriaOperator.FromLambda<Order, bool>(o => new string[] { "Order2", "Order3", "Description5" }.Contains(o.OrderName));

Typed

new InOperator("OrderName", new string[] { "Order2", "Order3", "Description5" });

String

CriteriaOperator.Parse("OrderName In ('Order2', 'Order3','Description5')");

Test

Input:

OrderName
Order0
Order1
Order2
Order3

The result:

OrderName
Order2
Order3

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the InOperator 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/PatchCriteriaExample/Filtering/CriteriaPatcherSkipProperties.cs#L55

public override CriteriaOperator Visit(InOperator theOperator) {
    var result = (InOperator)base.Visit(theOperator);

VB.NET

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

Public Overrides Function Visit(ByVal theOperator As InOperator) As CriteriaOperator
    Dim result = CType(MyBase.Visit(theOperator), InOperator)

Inheritance

Object

CriteriaOperator

InOperator