AdvancedFilterBuilder class

包:

powerbi-client

Power BI 高级筛选器生成器组件

扩展

FilterBuilder

继承属性

target

方法

addCondition(AdvancedFilterConditionOperators, string | number | boolean | Date)	在高级筛选器中添加条件 // Add two conditions const advancedFilterBuilder = new AdvancedFilterBuilder().addCondition("Contains", "Wash").addCondition("Contains", "Park");
and()	设置“高级”筛选器的“和”逻辑运算符” const advancedFilterBuilder = new AdvancedFilterBuilder().and();
build()	创建高级筛选器 const advancedFilterBuilder = new AdvancedFilterBuilder().build();
or()	设置或作为高级筛选器的逻辑运算符 const advancedFilterBuilder = new AdvancedFilterBuilder().or();

继承的方法

withColumnAggregation(string, string, string)	使用列聚合目标对象设置筛选器的目标属性 const filterBuilder = new FilterBuilder().withColumnAggregation(tableName, columnName, aggregationFunction);
withColumnTarget(string, string)	使用列目标对象设置筛选器的目标属性 const filterBuilder = new FilterBuilder().withColumnTarget(tableName, columnName);
withHierarchyLevelAggregationTarget(string, string, string, string)	使用层次结构级别聚合目标对象设置筛选器的目标属性 const filterBuilder = new FilterBuilder().withHierarchyLevelAggregationTarget(tableName, hierarchy, hierarchyLevel, aggregationFunction);
withHierarchyLevelTarget(string, string, string)	使用层次结构级别目标对象设置筛选器的目标属性 const filterBuilder = new FilterBuilder().withHierarchyLevelTarget(tableName, hierarchy, hierarchyLevel);
withMeasureTarget(string, string)	使用度量值目标对象设置筛选器的目标属性 const filterBuilder = new FilterBuilder().withMeasureTarget(tableName, measure);
withTargetObject(IFilterTarget)	使用目标对象设置筛选器的目标属性 const target = { table: 'table1', column: 'column1' }; const filterBuilder = new FilterBuilder().withTargetObject(target);

继承属性详细信息

target

target: IFilterTarget

属性值

IFilterTarget

继承自FilterBuilder.target

方法详细信息

addCondition(AdvancedFilterConditionOperators, string | number | boolean | Date)

在高级筛选器中添加条件

// Add two conditions
const advancedFilterBuilder = new AdvancedFilterBuilder().addCondition("Contains", "Wash").addCondition("Contains", "Park");

function addCondition(operator: AdvancedFilterConditionOperators, value?: string | number | boolean | Date): AdvancedFilterBuilder

参数

operator

AdvancedFilterConditionOperators

value

string | number | boolean | Date

返回

AdvancedFilterBuilder

and()

设置“高级”筛选器的“和”逻辑运算符”

const advancedFilterBuilder = new AdvancedFilterBuilder().and();

function and(): AdvancedFilterBuilder

返回

AdvancedFilterBuilder

build()

创建高级筛选器

const advancedFilterBuilder = new AdvancedFilterBuilder().build();

function build(): AdvancedFilter

返回

AdvancedFilter

or()

设置或作为高级筛选器的逻辑运算符

const advancedFilterBuilder = new AdvancedFilterBuilder().or();

function or(): AdvancedFilterBuilder

返回

AdvancedFilterBuilder

继承的方法详细信息

withColumnAggregation(string, string, string)

使用列聚合目标对象设置筛选器的目标属性

const filterBuilder = new FilterBuilder().withColumnAggregation(tableName, columnName, aggregationFunction);

function withColumnAggregation(tableName: string, columnName: string, aggregationFunction: string): AdvancedFilterBuilder

参数

tableName

string

columnName

string

aggregationFunction

string

返回

AdvancedFilterBuilder

继承自FilterBuilder.withColumnAggregation

withColumnTarget(string, string)

使用列目标对象设置筛选器的目标属性

const filterBuilder = new FilterBuilder().withColumnTarget(tableName, columnName);

function withColumnTarget(tableName: string, columnName: string): AdvancedFilterBuilder

参数

tableName

string

columnName

string

返回

AdvancedFilterBuilder

继承自FilterBuilder.withColumnTarget

withHierarchyLevelAggregationTarget(string, string, string, string)

使用层次结构级别聚合目标对象设置筛选器的目标属性

const filterBuilder = new FilterBuilder().withHierarchyLevelAggregationTarget(tableName, hierarchy, hierarchyLevel, aggregationFunction);

function withHierarchyLevelAggregationTarget(tableName: string, hierarchy: string, hierarchyLevel: string, aggregationFunction: string): AdvancedFilterBuilder

参数

tableName

string

hierarchy

string

hierarchyLevel

string

aggregationFunction

string

返回

AdvancedFilterBuilder

继承自FilterBuilder.withHierarchyLevelAggregationTarget

withHierarchyLevelTarget(string, string, string)

使用层次结构级别目标对象设置筛选器的目标属性

const filterBuilder = new FilterBuilder().withHierarchyLevelTarget(tableName, hierarchy, hierarchyLevel);

function withHierarchyLevelTarget(tableName: string, hierarchy: string, hierarchyLevel: string): AdvancedFilterBuilder

参数

tableName

string

hierarchy

string

hierarchyLevel

string

返回

AdvancedFilterBuilder

继承自FilterBuilder.withHierarchyLevelTarget

withMeasureTarget(string, string)

使用度量值目标对象设置筛选器的目标属性

const filterBuilder = new FilterBuilder().withMeasureTarget(tableName, measure);

function withMeasureTarget(tableName: string, measure: string): AdvancedFilterBuilder

参数

tableName

string

measure

string

返回

AdvancedFilterBuilder

继承自FilterBuilder.withMeasureTarget

withTargetObject(IFilterTarget)

使用目标对象设置筛选器的目标属性

const target = {
 table: 'table1',
 column: 'column1'
};

const filterBuilder = new FilterBuilder().withTargetObject(target);

function withTargetObject(target: IFilterTarget): AdvancedFilterBuilder

参数

target

IFilterTarget

返回

AdvancedFilterBuilder

继承自FilterBuilder.withTargetObject