PivotGridFieldFilterValues.Values Property

Gets or sets an array of filter values.

Namespace: DevExpress.XtraPivotGrid

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

Declaration

C#

[XtraSerializableProperty(0)]
[XtraSerializablePropertyId(100)]
public object[] Values { get; set; }

VB.NET

<XtraSerializableProperty(0)>
<XtraSerializablePropertyId(100)>
Public Property Values As Object()

Property Value

Type	Description
Object[]	An array of objects that represent the filter values.

Remarks

The Values property represents an array of filter values. If the PivotGridFieldFilterValues.FilterType property is set to the PivotFilterType.Included value, only the records which contain values from the Values array in a specific field are displayed by a pivot grid. Otherwise, if the PivotGridFieldFilterValues.FilterType property is set to the PivotFilterType.Excluded value, only the records which don’t contain values from the Values array in a specific field are displayed.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Values property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-obtain-active-filter-criteria-applied-to-pivotgridcontrols-fields-e1999/CS/WindowsApplication1/MyPivotGridFilterHelper.cs#L31

{
    object[] values = field.FilterValues.Values;
    if (values.Length == 0) return;

VB.NET

how-to-obtain-active-filter-criteria-applied-to-pivotgridcontrols-fields-e1999/VB/WindowsApplication1/MyPivotGridFilterHelper.vb#L28

Private Sub WriteFieldFilter(ByVal field As PivotGridField)
    Dim values() As Object = field.FilterValues.Values
    If values.Length = 0 Then