XPBaseCollection.Filter Property

Gets or sets the criteria used to filter objects on the client side.

Namespace: DevExpress.Xpo

Assembly: DevExpress.Xpo.v19.2.dll

Declaration

C#

[Browsable(false)]
public CriteriaOperator Filter { get; set; }

VB.NET

<Browsable(False)>
Public Property Filter As CriteriaOperator

Property Value

Type	Description
CriteriaOperator	A CriteriaOperator object that specifies the criteria to filter objects on the client side.

Remarks

The XPBaseCollection.Criteria property specifies the criteria used to filter objects on the storage side. After objects that meet these criteria are retrieved to the XPBaseCollection, they are filtered again by the Filter criteria.

To disable the criteria specified by the Filter property set this property to null (Nothing in Visual Basic).

Unlike the XPCollection’s XPBaseCollection.Criteria, Filter criteria can be built on non-persistent properties.

Note

For performance reasons, we recommend that you not use the JoinOperand when building criteria for the Filter property, as this significantly increases the number of queries sent to the server.

Related GitHub Examples

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

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_tutorial-3-querying-data-e4559/CS/XpoTutorial3/XtraForm1.cs#L49

private void simpleButton2_Click(object sender, EventArgs e) {
    xpCollection1.Filter = new BinaryOperator("Age", spinEdit2.Value, BinaryOperatorType.Greater);
    gridControl1.RefreshDataSource();

VB.NET

XPO_tutorial-3-querying-data-e4559/VB/XpoTutorial3/XtraForm1.vb#L51

Private Sub simpleButton2_Click(ByVal sender As Object, ByVal e As EventArgs) Handles simpleButton2.Click
    xpCollection1.Filter = New BinaryOperator("Age", spinEdit2.Value, BinaryOperatorType.Greater)
    gridControl1.RefreshDataSource()