Class Filter

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

Inheritance
object
Filter
Inherited Members
Namespace: Syncfusion.Blazor.PivotView
Assembly: Syncfusion.Blazor.dll
Syntax
public class Filter

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
[JsonPropertyName("condition")]
[JsonConverter(typeof(JsonStringEnumConverter))]
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
[JsonPropertyName("items")]
public string[] Items { get; set; }
Property Value
Type
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
[JsonPropertyName("levelCount")]
public int LevelCount { get; set; }
Property Value
Type
int

Measure

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

It is applicable only for label and value filtering.

Declaration
[JsonPropertyName("measure")]
public string Measure { get; set; }
Property Value
Type
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
[JsonPropertyName("name")]
public string Name { get; set; }
Property Value
Type
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
[JsonPropertyName("selectedField")]
public string SelectedField { get; set; }
Property Value
Type
string

ShowDateFilter

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

Declaration
[JsonPropertyName("showDateFilter")]
public bool ShowDateFilter { get; set; }
Property Value
Type
bool

ShowLabelFilter

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

Declaration
[JsonPropertyName("showLabelFilter")]
public bool ShowLabelFilter { get; set; }
Property Value
Type
bool

ShowNumberFilter

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

Declaration
[JsonPropertyName("showNumberFilter")]
public bool ShowNumberFilter { get; set; }
Property Value
Type
bool

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
[JsonPropertyName("type")]
[JsonConverter(typeof(JsonStringEnumConverter))]
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
[JsonPropertyName("value1")]
public string Value1 { get; set; }
Property Value
Type
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
[JsonPropertyName("value2")]
public string Value2 { get; set; }
Property Value
Type
string