PivotGridFieldOptions.ShowInPrefilter Property

Gets or sets whether the field is shown in Prefilter.

Namespace: DevExpress.XtraPivotGrid

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

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.WindowsDesktop.PivotGrid.Core

Declaration

C#

[DefaultValue(true)]
public virtual bool ShowInPrefilter { get; set; }

VB.NET

<DefaultValue(True)>
Public Overridable Property ShowInPrefilter As Boolean

Property Value

Type	Default	Description
Boolean	**true**	True if the field is shown in Prefilter; otherwise, false.

Property Paths

You can access this nested property as listed below:

Library	Object Type	Path to ShowInPrefilter
Cross-Platform Class Library	PivotGridFieldBase	.Options .ShowInPrefilter
WinForms Controls	PivotGridField	.Options .ShowInPrefilter
Reporting	XRPivotGridField	.Options .ShowInPrefilter
ASP.NET MVC Extensions	MVCxPivotGridField	.Options .ShowInPrefilter
ASP.NET Web Forms Controls	PivotGridField	.Options .ShowInPrefilter

Remarks

If the ShowInPrefilter property is set to false, the field is not displayed in the drop-down filed list invoked in the PreFilter window, as the Category Name field in the picture below…

… and the Prefilter editor does not recognize the field’s name:

It may prevent end-users from using the current field in prefilter criteria.

Note

The PivotGridFieldOptions.ShowInPrefilter and PivotGridFieldOptions.ShowInFilter properties are aliased and have the same values.

Tip

You can also prevent end-users from displaying the filter drop-down list by setting the PivotGridFieldOptions.AllowFilter field’s property to false.