PivotGridOptionsData.FilterByVisibleFieldsOnly Property

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

Namespace: DevExpress.XtraPivotGrid

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

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.WindowsDesktop.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:

Library	Object Type	Path to FilterByVisibleFieldsOnly
WinForms Controls	PivotGridControl	.OptionsData .FilterByVisibleFieldsOnly
Reporting	XRPivotGrid	.OptionsData .FilterByVisibleFieldsOnly
ASP.NET MVC Extensions	MVCxPivotGrid	.OptionsData .FilterByVisibleFieldsOnly
	PivotGridSettings	.OptionsData .FilterByVisibleFieldsOnly
ASP.NET Web Forms Controls	ASPxPivotGrid	.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.