XPView.Criteria Property
Gets or sets the criteria associated with the view.
Namespace: DevExpress.Xpo
Assembly: DevExpress.Xpo.v24.1.dll
NuGet Packages: DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap, DevExpress.Xpo
#Declaration
[DefaultValue(null)]
public CriteriaOperator Criteria { get; set; }
#Property Value
Type | Default | Description |
---|---|---|
Criteria |
null | A Criteria |
#Remarks
Use the Criteria property to change the criteria by which the persistent objects will be filtered while the view is being loaded. Changing this property immediately refreshes the view.
For examples and additional information about filter expressions, see these help topics:
- How to: Build Simple Criteria
- How to: Build Complex Criteria
- Build Criteria - Cheat Sheet
- Filtering
- Criteria Language Syntax
#Example
The following sample code demonstrates how to display persons who are older than 30. Only those persistent objects whose Age property’s value is greater than 30 are retrieved.
The image below shows the result.
using DevExpress.Xpo;
using DevExpress.Data.Filtering;
// ...
class SampleTable : XPBaseObject {
private int id;
private string name;
private int age;
SampleTable(Session session) : base(session) {
this.name = "John";
this.age = 25;
}
[Key(true)]
public int ID {
get { return id; }
set { SetPropertyValue<int>(nameof(ID), id, value); }
}
public string Name {
get { return name; }
set { SetPropertyValue<string>(nameof(Name), name, value); }
}
public int Age {
get { return age; }
set { SetPropertyValue<int>(nameof(Age), age, value); }
}
}
// ...
xpView1.Criteria = CriteriaOperator.Parse("Age > 30", null);
#Related GitHub Examples
The following code snippet (auto-collected from DevExpress Examples) contains a reference 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.