Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

PivotGridField.SetFilterValues(Object[], FieldFilterType, Boolean) Method

Adds the specified filter values to the collection.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v24.2.dll

NuGet Package: DevExpress.Wpf.PivotGrid

#Declaration

public void SetFilterValues(
    object[] values,
    FieldFilterType filterType,
    bool showBlanks
)

#Parameters

Name Type Description
values Object[]

An object that represents a collection of field filter values.

filterType FieldFilterType

A FieldFilterType enumeration member that specifies the filter type.

showBlanks Boolean

True, to show blank values; otherwise, false.

#Remarks

You can get or set the field filter values collection by using the PivotGridField.FieldFilterValues property.

To add filter values to the collection asynchronously, use the PivotGridField.SetFilterValuesAsync method.

#Example

This example shows how to apply a filter to a field.

The first filter selects records which contain UK in the fieldCountry field, the second filter selects four categories in the fieldCategoryName field: Beverages, Condiments, Seafood, and Produce.

    fieldCountry.SetFilterValues(new string[] { "UK" }, FieldFilterType.Included, true);
    fieldCategoryName.SetFilterValues(new string[] { "Beverages", "Condiments", "Seafood", "Produce" }, FieldFilterType.Included, true);
See Also