PivotGridControl.FilterString Property

Gets or sets the filter expression used to filter PIvotGridControl’s data. This is an attached property.

Namespace : DevExpress.Xpf.PivotGrid

Assembly : DevExpress.Xpf.PivotGrid.v25.2.dll

NuGet Package : DevExpress.Wpf.PivotGrid

Declaration

csharp

[Browsable(false)]
public string FilterString { get; set; }

<Browsable(False)>
Public Property FilterString As String

Type	Description
String

A filter expression

The FilterString property allows you to specify a filter string:

csharp

grid.FilterString = "([OrderDate] < #1/1/2018# AND [UnitPrice] < 10)" +
    " OR ([OrderDate] >= #1/1/2019# AND [UnitPrice] >= 100)";

grid.FilterString = "([OrderDate] < #1/1/2018# AND [UnitPrice] < 10)" & 
    " OR ([OrderDate] >= #1/1/2019# AND [UnitPrice] >= 100)"

End users can invoke the Filter Editor to modify filter criteria, and therefore, the FilterString property.