PivotGroupFilterValuesCollection.Add(Object) Method

Creates a filter value that corresponds to the specified field value, and adds it to the collection.

Namespace: DevExpress.XtraPivotGrid

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

Declaration

C#

public PivotGroupFilterValue Add(
    object value
)

VB.NET

Public Function Add(
    value As Object
) As PivotGroupFilterValue

Parameters

Name	Type	Description
value	Object	The field value for which the filter value should be created and added to the collection.

Returns

Type	Description
PivotGroupFilterValue	A PivotGroupFilterValue object representing the filter value that has been added to the collection.

Remarks

Several filter values cannot correspond to a single field value. If a filter value corresponding to the same field value (with the same DevExpress.XtraPivotGrid.PivotFilterValue.Value) is already contained in the collection, an exception is thrown. To obtain whether a particular field value is already represented in the collection, use the PivotGroupFilterValuesCollection.ContainsValue method.

To remove a filter value from the collection, use the PivotGroupFilterValuesCollection.Remove method.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Add(Object) method.

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-implement-the-group-filter-for-a-pivotgrid-e2518/CS/DXPivotGrid_GroupFilter/MainWindow.xaml.cs#L48

DevExpress.XtraPivotGrid.PivotGroupFilterValue value =
    group.FilterValues.Values.Add(year);
foreach (object month in group.GetUniqueValues(new object[] { year })) {

how-to-implement-the-group-filter-for-a-pivotgrid-e2315/CS/Form1.cs#L47

foreach(object year in group.GetUniqueValues(null)) {
    PivotGroupFilterValue value = group.FilterValues.Values.Add(year);
    foreach(object month in group.GetUniqueValues(new object[] { year })) {

how-to-implement-the-group-filter-for-a-pivotgrid-e3721/CS/ASPxPivotGrid_GroupFilter/Default.aspx.cs#L39

foreach (object year in group.GetUniqueValues(null)) {
    PivotGroupFilterValue value = group.FilterValues.Values.Add(year);
    foreach (object month in group.GetUniqueValues(new object[] { year })) {

how-to-implement-group-filter-for-a-pivotgridcontrol-e4581/CS/GroupFilter/Form1.cs#L31

// Then creates a child value of the filter value and adds it to the parent value collection.
OrderDateGroup.FilterValues.Values.Add(2015).ChildValues.Add(1);

VB.NET

how-to-implement-the-group-filter-for-a-pivotgrid-e3721/VB/ASPxPivotGrid_GroupFilter/Default.aspx.vb#L19

group.FilterValues.FilterType = PivotFilterType.Included
group.FilterValues.Values.Add(2014).ChildValues.Add(12)
group.FilterValues.Values.Add(2015).ChildValues.Add(1)

how-to-implement-the-group-filter-for-a-pivotgrid-e2518/VB/DXPivotGrid_GroupFilter/MainWindow.xaml.vb#L50

Dim value As DevExpress.XtraPivotGrid.PivotGroupFilterValue = _
    group.FilterValues.Values.Add(year)
For Each month As Object In group.GetUniqueValues(New Object() { year })

how-to-implement-group-filter-for-a-pivotgridcontrol-e4585/VB/GroupFilter/MainWindow.xaml.vb#L28

' Creates a filter value and adds it to the PivotGroupFilterValues.Values collection.
OrderDateGroup.FilterValues.Values.Add(1994)

how-to-implement-group-filter-for-aspxpivotgrid-e4584/VB/GroupFilter/Default.aspx.vb#L23

' Creates a filter value and adds it to the PivotGroupFilterValues.Values collection.
OrderDateGroup.FilterValues.Values.Add(1994)

how-to-implement-the-group-filter-for-a-pivotgrid-e2315/VB/Form1.vb#L49

For Each year As Object In group.GetUniqueValues(Nothing)
    Dim value As PivotGroupFilterValue = group.FilterValues.Values.Add(year)
    For Each month As Object In group.GetUniqueValues(New Object() { year })