PivotGridOptionsData.FilterByVisibleFieldsOnly Property

Gets or sets whether to take into account filter conditions of visible filter fields only.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v21.2.Core.dll

NuGet Package: DevExpress.PivotGrid.Core

Declaration

C#

[DefaultValue(false)]
public bool FilterByVisibleFieldsOnly { get; set; }

VB.NET

<DefaultValue(False)>
Public Property FilterByVisibleFieldsOnly As Boolean

Property Value

Type	Default	Description
Boolean	false	true to take into account filter conditions of visible filter fields only; false, to take into account filter conditions of all filter fields.

Property Paths

You can access this nested property as listed below:

Object Type	Path to FilterByVisibleFieldsOnly
PivotGridControl	.OptionsData .FilterByVisibleFieldsOnly

Remarks

By default, filter conditions of all filter fields are taken into account when filtering, regardless of the field’s visibility. Set the FilterByVisibleFieldsOnly property to true to ignore filter fields whose PivotGridFieldBase.Visible property is set to false.

The FilterByVisibleFieldsOnly property is in effect for fields located in the Filter Area only. Filter conditions of fields located in other areas are taken into account only if the field is visible.