XPBaseCollection.Criteria Property

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

Namespace: DevExpress.Xpo

Assembly: DevExpress.Xpo.v21.1.dll

NuGet Package: DevExpress.Xpo

Declaration

C#

public CriteriaOperator Criteria { get; set; }

VB.NET

Public Property Criteria As CriteriaOperator

Property Value

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

Remarks

Use the Criteria property in order to change the criteria by which the persistent objects will be filtered during collection loading on the storage side. If you change this property’s value, the collection is refreshed immediately. But if you change any of its criteria members, you must call the XPBaseCollection.Reload method in order to force loading. To temporarily prevent a collection from loading/reloading data use the XPBaseCollection.LoadingEnabled property.

For examples and additional information about filter expressions, see these help topics:

• How to: Build Simple Criteria
• How to: Build Complex Criteria
• Filtering
• Criteria Language Syntax

Note

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

Related GitHub Examples

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

how-to-implement-an-ifilteredcomponent-interface-e1350/CS/Q200298/Helper.cs#L176

    if (source == null) return null;
    return source.Criteria;
}

XPO_tutorial-3-querying-data-e4559/CS/XpoTutorial3/XtraForm1.cs#L44

private void simpleButton1_Click(object sender, EventArgs e) {
    xpCollection1.Criteria = new BinaryOperator("Age", spinEdit1.Value, BinaryOperatorType.Greater);
    gridControl1.RefreshDataSource();

XPO_how-to-create-a-filter-with-an-aggregate-function-for-a-child-collection-e1329/CS/Form1.cs#L303

void SetFilter(CriteriaOperator criteria) {
    xpCollection1.Criteria = criteria;

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

void SetFilter(CriteriaOperator criteria) {
    xpCollection1.Criteria = criteria;

XAF_how-to-filter-users-by-their-roles-e210/CS/WinSolution.Module/DomainObject1.cs#L46

private void UpdateAddressDataSource() {
    myUserDataSourceInternal.Criteria = MyRole != null ? CriteriaOperator.Parse("MyRoles[RoleName = ?]", MyRole.RoleName) : null;
}

VB.NET

how-to-implement-an-ifilteredcomponent-interface-e1350/VB/Q200298/Helper.vb#L215

    End If
    Return source_Renamed.Criteria
End Get

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

Private Sub simpleButton1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles simpleButton1.Click
    xpCollection1.Criteria = New BinaryOperator("Age", spinEdit1.Value, BinaryOperatorType.Greater)
    gridControl1.RefreshDataSource()

XAF_how-to-filter-users-by-their-roles-e210/VB/WinSolution.Module/DomainObject1.vb#L63

If Not MyRole Is Nothing Then
    myUserDataSourceInternal.Criteria = CriteriaOperator.Parse("MyRoles[RoleName = ?]", MyRole.RoleName)
Else

XPO_how-to-create-a-filter-with-an-aggregate-function-for-a-child-collection-e1329/VB/Form1.vb#L288

Private Sub SetFilter(ByVal criteria As CriteriaOperator)
    xpCollection1.Criteria = criteria

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

Private Sub SetFilter(ByVal criteria As CriteriaOperator)
    xpCollection1.Criteria = criteria