ContainsOperator Class

An operator which checks if a collection contains at least one object matching a specific criteria.

Namespace: DevExpress.Data.Filtering

Assembly: DevExpress.Data.v21.2.dll

Declaration

C#

public sealed class ContainsOperator :
    AggregateOperand

VB.NET

Public NotInheritable Class ContainsOperator
    Inherits AggregateOperand

Remarks

The ContainsOperator operator can be used to filter the contents of the XPCollection.

It’s also possible to use the CriteriaOperator.Parse method to create a CriteriaOperator operator for a specific expression.

Example

This sample code selects Person objects that contain at least one object in their Addresses collection property with the City property set to “Chicago”

The image below shows the result:

C#

xpCollection1.Filter = new ContainsOperator("Addresses", new BinaryOperator("City", "Chicago"));
//or
xpCollection1.Filter = CriteriaOperator.Parse("[Addresses][[City] = ?]", "Chicago");

VB.NET

xpCollection1.Filter = New ContainsOperator("Addresses", New BinaryOperator("City", "Chicago"))
'or
xpCollection1.Filter = CriteriaOperator.Parse("[Addresses][[City] = ?]", "Chicago")

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ContainsOperator 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#

XPO_how-to-use-the-containsoperator-for-objects-in-a-many-to-many-relationship-e988/CS/A2404/Form1.cs#L50

    Role manager = XpoDefault.Session.FindObject<Role>(new BinaryOperator("RoleName", "Manager"));
    dataGridView1.DataSource = new XPCollection(typeof(User), new ContainsOperator("Roles", new BinaryOperator("This", manager)));
}

XPO_how-to-filter-a-collection-by-an-associated-objects-properties-e886/CS/Form1.cs#L312

private void btnFiterStandard_Click(object sender, System.EventArgs e) {
    CriteriaOperator criteria = new ContainsOperator("Orders", new BinaryOperator("Employee.LastName", "Buchanan"));
    SetFilter(criteria);

VB.NET

XPO_how-to-use-the-containsoperator-for-objects-in-a-many-to-many-relationship-e988/VB/A2404/Form1.vb#L60

    Dim manager As Role = XpoDefault.Session.FindObject(Of Role)(New BinaryOperator("RoleName", "Manager"))
    dataGridView1.DataSource = New XPCollection(GetType(User), New ContainsOperator("Roles", New BinaryOperator("This", manager)))
End Sub

XPO_how-to-filter-a-collection-by-an-associated-objects-properties-e886/VB/Form1.vb#L303

Private Sub btnFiterStandard_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnFiterStandard.Click
    Dim criteria As CriteriaOperator = New ContainsOperator("Orders", New BinaryOperator("Employee.LastName", "Buchanan"))
    SetFilter(criteria)

Inheritance

Object

CriteriaOperator

AggregateOperand

ContainsOperator