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.v19.2.dll

Declaration

C#

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

VB.NET

<Browsable(False)>
Public Property FilterString As String

Property Value

Type	Description
String	A filter expression

Remarks

The FilterString property allows you to specify a filter string:

C#

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

VB.NET

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.