The following code snippet illustrates how to create filter criteria that are a DevExpress.Data.Filtering.CriteriaOperator descendant and assign them to the FilterCriteria property:
| C# |
pivotGridControl1.FilterCriteria = (
new BinaryOperator("OrderDate", new DateTime(2018, 1, 1), BinaryOperatorType.Less) &
new BinaryOperator("UnitPrice", 10, BinaryOperatorType.Less)) |
( new BinaryOperator("OrderDate", new DateTime(2019, 1, 1), BinaryOperatorType.GreaterOrEqual) &
new BinaryOperator("UnitPrice", 100, BinaryOperatorType.GreaterOrEqual));
|
| VB |
pivotGridControl1.FilterCriteria = (
New BinaryOperator("OrderDate", New DateTime(2018, 1, 1), BinaryOperatorType.Less) And
New BinaryOperator("UnitPrice", 10, BinaryOperatorType.Less)) Or
(New BinaryOperator("OrderDate", New DateTime(2019, 1, 1), BinaryOperatorType.GreaterOrEqual) And
New BinaryOperator("UnitPrice", 100, BinaryOperatorType.GreaterOrEqual))
|
You can obtain filter criteria by parsing a filter string with the static DevExpress.Data.Filtering.CriteriaOperator.Parse method:
| C# |
pivotGridControl1.FilterCriteria =
CriteriaOperator.Parse("([OrderDate] < #1/1/2018# AND [UnitPrice] < 10)" +
" OR ([OrderDate] >= #1/1/2019# AND [UnitPrice] >= 100)");
|
| VB |
pivotGridControl1.FilterCriteria =
CriteriaOperator.Parse("([OrderDate] < #1/1/2018# AND [UnitPrice] < 10)" &
" OR ([OrderDate] >= #1/1/2019# AND [UnitPrice] >= 100)")
|