PivotCustomFilterPopupItemsEventArgs Class
Provides data for the PivotGridControl.CustomFilterPopupItems event.
Namespace: DevExpress.Xpf.PivotGrid
Assembly: DevExpress.Xpf.PivotGrid.v24.1.dll
NuGet Package: DevExpress.Wpf.PivotGrid
Declaration
Remarks
The PivotGridControl.CustomFilterPopupItems event allows you to customize the filter drop-down list items. The PivotCustomFilterPopupItemsEventArgs class provides the PivotCustomFilterPopupItemsEventArgs.Items property used to access the filter items collection. Elements of the collection are represented by the PivotGridFilterItem objects. Initially, the filter items collection contains items representing the unique values stored in the underlying data source in the current field. To hide a filter item from the drop-down list, remove the corresponding element from the collection.
To specify the check state of individual filter items, use their PivotGridFilterItem.IsChecked properties. To do this for all filter items, use the PivotCustomFilterPopupItemsEventArgs.CheckAllItems method.
You can also obtain the field for which the event has been raised using the PivotCustomFilterPopupItemsEventArgs.Field property.
The filter drop-down list contains the ‘Show Blanks’ item used to control whether the data records that contain null values in the respective field are processed by the pivot grid. To access the ‘Show Blanks’ filter item, use the PivotCustomFilterPopupItemsEventArgs.ShowBlanksItem property.
Note
In the OLAP mode, the PivotCustomFilterPopupItemsEventArgs.ShowBlanksItem property returns null.