Class FilterItemsCollection

Class that holds the collection of objects that are filtered.

Inheritance
System.Object
System.Collections.Generic.List<FilterItemElement>
FilterItemsCollection
Implements
System.Collections.Generic.IList<FilterItemElement>
System.Collections.Generic.ICollection<FilterItemElement>
System.Collections.IList
System.Collections.ICollection
System.Collections.Generic.IReadOnlyList<FilterItemElement>
System.Collections.Generic.IReadOnlyCollection<FilterItemElement>
System.Collections.Generic.IEnumerable<FilterItemElement>
System.Collections.IEnumerable
Inherited Members
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.Add(Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.AddRange(System.Collections.Generic.IEnumerable<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.AsReadOnly()
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.BinarySearch(Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.BinarySearch(Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement, System.Collections.Generic.IComparer<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.BinarySearch(System.Int32, System.Int32, Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement, System.Collections.Generic.IComparer<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.Capacity
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.Clear()
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.Contains(Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.ConvertAll<TOutput>(System.Converter<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement, TOutput>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.CopyTo(Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement[])
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.CopyTo(Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement[], System.Int32)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.CopyTo(System.Int32, Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement[], System.Int32, System.Int32)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.Count
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.Exists(System.Predicate<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.Find(System.Predicate<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.FindAll(System.Predicate<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.FindIndex(System.Int32, System.Int32, System.Predicate<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.FindIndex(System.Int32, System.Predicate<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.FindIndex(System.Predicate<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.FindLast(System.Predicate<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.FindLastIndex(System.Int32, System.Int32, System.Predicate<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.FindLastIndex(System.Int32, System.Predicate<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.FindLastIndex(System.Predicate<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.ForEach(System.Action<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.GetEnumerator()
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.GetRange(System.Int32, System.Int32)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.IndexOf(Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.IndexOf(Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement, System.Int32)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.IndexOf(Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement, System.Int32, System.Int32)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.Insert(System.Int32, Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.InsertRange(System.Int32, System.Collections.Generic.IEnumerable<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.Item[System.Int32]
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.LastIndexOf(Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.LastIndexOf(Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement, System.Int32)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.LastIndexOf(Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement, System.Int32, System.Int32)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.Remove(Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.RemoveAll(System.Predicate<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.RemoveAt(System.Int32)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.RemoveRange(System.Int32, System.Int32)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.Reverse()
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.Reverse(System.Int32, System.Int32)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.Sort()
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.Sort(System.Collections.Generic.IComparer<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.Sort(System.Comparison<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.Sort(System.Int32, System.Int32, System.Collections.Generic.IComparer<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.System.Collections.Generic.ICollection<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.IsReadOnly
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.System.Collections.Generic.IEnumerable<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.GetEnumerator()
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.System.Collections.ICollection.CopyTo(System.Array, System.Int32)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.System.Collections.ICollection.IsSynchronized
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.System.Collections.ICollection.SyncRoot
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.System.Collections.IEnumerable.GetEnumerator()
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.System.Collections.IList.Add(System.Object)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.System.Collections.IList.Contains(System.Object)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.System.Collections.IList.get_Item(System.Int32)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.System.Collections.IList.IndexOf(System.Object)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.System.Collections.IList.Insert(System.Int32, System.Object)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.System.Collections.IList.IsFixedSize
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.System.Collections.IList.IsReadOnly
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.System.Collections.IList.Item[System.Int32]
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.System.Collections.IList.Remove(System.Object)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.System.Collections.IList.set_Item(System.Int32, System.Object)
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.ToArray()
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.TrimExcess()
System.Collections.Generic.List<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>.TrueForAll(System.Predicate<Syncfusion.XlsIO.Implementation.PivotAnalysis.FilterItemElement>)
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: Syncfusion.XlsIO.Implementation.PivotAnalysis
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
public class FilterItemsCollection : List<FilterItemElement>, IList<FilterItemElement>, ICollection<FilterItemElement>, IList, ICollection, IReadOnlyList<FilterItemElement>, IReadOnlyCollection<FilterItemElement>, IEnumerable<FilterItemElement>, IEnumerable

Constructors

FilterItemsCollection()

Initializes a new instance of the FilterItemsCollection class.

Declaration
public FilterItemsCollection()

Properties

AllFilterItem

Gets or sets the property with all the filter items.

Declaration
public FilterItemElement AllFilterItem { get; set; }
Property Value
Type
FilterItemElement

AllowRunTimeGroupByField

Gets or sets the value to enable/disable grouping for the filter item. Default value is true.

Declaration
public bool AllowRunTimeGroupByField { get; set; }
Property Value
Type
System.Boolean

Comparer

Gets or sets the comparer of all PivotFields in the Pivot control.

Declaration
public IComparer Comparer { get; set; }
Property Value
Type
System.Collections.IComparer

DisplayHeader

Gets or sets the header value for the PivotItem.

Declaration
public string DisplayHeader { get; set; }
Property Value
Type
System.String

FieldCaption

Gets or sets the caption value for the PivotItem.

Declaration
public string FieldCaption { get; set; }
Property Value
Type
System.String

FilteredValues

Gets or sets the filtered values.

Declaration
public List<string> FilteredValues { get; set; }
Property Value
Type
System.Collections.Generic.List<System.String>

FilterProperty

Gets or sets the filter property.

Declaration
public PropertyDescriptor FilterProperty { get; set; }
Property Value
Type
System.ComponentModel.PropertyDescriptor

Format

Gets or sets the format for the PivotItem.

Declaration
public string Format { get; set; }
Property Value
Type
System.String

Name

Gets or sets the content for the name property.

Declaration
public string Name { get; set; }
Property Value
Type
System.String

ShowSubTotal

Gets or sets the value to show/hide sub-totals for the PivotItem. Default value is true.

Declaration
public bool ShowSubTotal { get; set; }
Property Value
Type
System.Boolean

Methods

AcceptChanges()

Accept the changes in the filter items collection.

Declaration
public void AcceptChanges()

AddIfUnique(FilterItemElement)

Returns the respective location to add the filter item.

Declaration
public int AddIfUnique(FilterItemElement filterItemElement)
Parameters
Type Name Description
FilterItemElement filterItemElement

Filter item.
Returns
Type Description
System.Int32

Location to add the filter item.

AddWireEvent(FilterItemElement)

Add filter item in the collection.

Declaration
public void AddWireEvent(FilterItemElement element)
Parameters
Type Name Description
FilterItemElement element

Filter item.

GetFilterExpression(Boolean)

To get the filter expression from IEnumerable source.

Declaration
public string GetFilterExpression(bool IEnumerableSource)
Parameters
Type Name Description
System.Boolean IEnumerableSource
Returns
Type
System.String

GetFilterExpression(Boolean, FilterItemsCollection, String)

Returns the filter expression for the filter items collection from IEnumerable source.

Declaration
public string GetFilterExpression(bool IEnumerableSource, FilterItemsCollection filterItemsCollection, string format)
Parameters
Type Name Description
System.Boolean IEnumerableSource
FilterItemsCollection filterItemsCollection
System.String format
Returns
Type
System.String

GetFilterExpressionForDataView()

To get the filter expression for DataView source.

Declaration
public string GetFilterExpressionForDataView()
Returns
Type Description
System.String

Filter expression.

GetFilterItem()

Returns key of the filter item, if the filter items are selected else returns empty string.

Declaration
public string GetFilterItem()
Returns
Type
System.String

RejectChanges()

Rejects the changes in filter items collection.

Declaration
public void RejectChanges()

SetName(String)

Method used to set the name of the filter item.

Declaration
public void SetName(string name)
Parameters
Type Name Description
System.String name

Name of the filter item.

Implements

System.Collections.Generic.IList<T>
System.Collections.Generic.ICollection<T>
System.Collections.IList
System.Collections.ICollection
System.Collections.Generic.IReadOnlyList<T>
System.Collections.Generic.IReadOnlyCollection<T>
System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable

Extension Methods