menu

Blazor

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class Filter - Blazor API Reference | Syncfusion

    Show / Hide Table of Contents

    Class Filter

    Allows specific fields associated with either selective or conditional-based filter members that used to be displayed in the pivot table.

    Inheritance
    System.Object
    Filter
    Namespace: Syncfusion.Blazor.PivotView
    Assembly: Syncfusion.Blazor.dll
    Syntax
    public class Filter : Object

    Constructors

    Filter()

    Declaration
    public Filter()

    Properties

    Condition

    Allows you to choose the operator type such as equals, greater than, less than, etc. for conditional-based filtering.

    It is applicable only for label and value filtering.

    Declaration
    public Operators Condition { get; set; }
    Property Value
    Type
    Operators

    Items

    Allows yoy to specify the field members that used to be displayed based on the filter type provided in the pivot table.

    Declaration
    public string[] Items { get; set; }
    Property Value
    Type
    System.String[]

    LevelCount

    Allows to set level of the field to fetch data from the cube for filtering.

    This option is applicable only for user-defined hierarchies in OLAP data source.

    Declaration
    public int LevelCount { get; set; }
    Property Value
    Type
    System.Int32

    Measure

    Allows to set value field for evaluation using conditions and operands for filtering.

    It is applicable only for label and value filtering.

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

    Name

    Allows you to set the field name that used to display the selective or conditional-based filter members that used to be displayed in the pivot table.

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

    SelectedField

    Allows to set level name of a specified field, where the filtering settings to be applied.

    This option is applicable only for user-defined hierarchies in OLAP data source.

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

    ShowDateFilter

    It allows excel-like date filtering operation through UI and code-behind.

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

    ShowLabelFilter

    It allows excel-like label filtering operation through UI and code-behind.

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

    ShowNumberFilter

    It allows excel-like number filtering operation through UI and code-behind.

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

    Type

    Allows you to set the specific filter type to display the filter members in the pivot table. They are: Include - Specifies the filter type as include. Exclude - Specifies the filter type as exclude. Label - Specifies the filter type as label. Date - Specifies the filter type as date. Number - Specifies the filter type as number. Value - Specifies the filter type as value.

    Declaration
    public FilterType Type { get; set; }
    Property Value
    Type
    FilterType

    Value1

    Allows you to set the start value to display the filter items in the pivot table based on the condition applied.

    It is applicable only for label and value filtering.

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

    Value2

    Allows you to set the end value to display the filter items in the pivot table based on the condition applied.

    This option will be used by default when the operator Between and NotBetween is chosen to apply. Also, it is applicable only for label and value filtering.

    Declaration
    public string Value2 { get; set; }
    Property Value
    Type
    System.String
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved