A newer version of this page is available. Switch to the current version.

jQuery PivotGrid - headerFilter

Configures the header filter feature.

Type:

Object

A header filter allows a user to filter individual field's values by including or excluding them from the applied filter. Clicking a header filter icon in the field chooser or the field panel invokes a popup menu displaying all the unique field values.

DevExtreme HTML5 JavaScript jQuery Angular Knockout UI component Pivot Grid Header Filter

Assign true to the allowFiltering property to make the icons visible. To customize a specific field's header filter, use the field's headerFilter object.

The user's filtering preferences are saved in the filterValues property. The header filter's Select All checkbox changes the filterType property.

View Demo

See Also

allowSearch

Specifies whether searching is enabled in the header filter.

Type:

Boolean

Default Value: false

height

Specifies the height of the popup menu containing filtering values.

Type:

Number

Default Value: 325

searchTimeout

Specifies a delay in milliseconds between when a user finishes typing in the header filter's search panel, and when the search is executed.

Type:

Number

Default Value: 500

showRelevantValues

Specifies whether to show all field values or only those that satisfy the other applied filters.

Type:

Boolean

Default Value: false

For example, a PivotGrid contains Continent and Country fields, and a user selects Europe in the Continent's header filter. If the Country's header filter should filter out all non-European countries, set this property to true.

View Demo

texts

Configures the texts of the popup menu's elements.

Type:

Object

width

Specifies the width of the popup menu containing filtering values.

Type:

Number

Default Value: 252