Skip to main content

FieldFilterValues.SetValues(Object[], FieldFilterType, Boolean) Method

Adds the specified values to the collection and sets the FieldFilterValues.FilterType and PivotGridFieldFilterValues.ShowBlanks properties to the specified values.

Namespace: DevExpress.Xpf.PivotGrid

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

Declaration

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

Parameters

Name Type Description
values Object[]

An array of objects which represent the filter values to add to the collection.

filterType FieldFilterType

A FieldFilterType value that specifies the current field’s filter type. This value is assigned to the FieldFilterValues.FilterType property.

showBlanks Boolean

A Boolean value that specifies whether the PivotGrid should process the records which contain NULL values in the current field. This value is assigned to the PivotGridFieldFilterValues.ShowBlanks property.

Remarks

This method clears the current collection and then adds the objects passed in the values array to the collection. The FieldFilterValues.FilterType and PivotGridFieldFilterValues.ShowBlanks properties are set to the specified values.

The FieldFilterValues.FilterType property determines how the filter values in the collection are handled. If it’s set to FieldFilterType.Excluded, the PivotGrid control will not display the records which contain filter values in the current field. All the other records will displayed. If the FieldFilterValues.FilterType property is set to FieldFilterType.Included, the PivotGrid will process only the records which contain the filter values in the current field. All the other records will be ignored.

The PivotGridFieldFilterValues.ShowBlanks property specifies whether the PivotGrid should process the records which contain NULL values in the current field.

See Also