RelativeDateFilterBuilder class

套件:

powerbi-client

Power BI 相對日期篩選產生器元件

Extends

FilterBuilder

繼承的屬性

target

方法

build()	建立相對日期篩選 const relativeDateFilterBuilder = new RelativeDateFilterBuilder().build();
includeToday(boolean)	Set includeToday for Relative Date filter const relativeDateFilterBuilder = new RelativeDateFilterBuilder().includeToday(includeToday);
inLast(number, RelativeDateFilterTimeUnit)	將 inLast 設定為相對日期篩選條件的運算子 const relativeDateFilterBuilder = new RelativeDateFilterBuilder().inLast(timeUnitsCount, timeUnitType);
inNext(number, RelativeDateFilterTimeUnit)	將 inNext 設定為相對日期篩選的運算子 const relativeDateFilterBuilder = new RelativeDateFilterBuilder().inNext(timeUnitsCount, timeUnitType);
inThis(number, RelativeDateFilterTimeUnit)	將 inThis 設定為相對日期篩選條件的運算子 const relativeDateFilterBuilder = new RelativeDateFilterBuilder().inThis(timeUnitsCount, timeUnitType);

繼承的方法

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

方法詳細資料

build()

建立相對日期篩選

const relativeDateFilterBuilder = new RelativeDateFilterBuilder().build();

function build(): RelativeDateFilter

傳回

RelativeDateFilter

includeToday(boolean)

Set includeToday for Relative Date filter

const relativeDateFilterBuilder = new RelativeDateFilterBuilder().includeToday(includeToday);

function includeToday(includeToday: boolean): RelativeDateFilterBuilder

參數

includeToday

boolean

表示今天是否包含

傳回

RelativeDateFilterBuilder

inLast(number, RelativeDateFilterTimeUnit)

將 inLast 設定為相對日期篩選條件的運算子

const relativeDateFilterBuilder = new RelativeDateFilterBuilder().inLast(timeUnitsCount, timeUnitType);

function inLast(timeUnitsCount: number, timeUnitType: RelativeDateFilterTimeUnit): RelativeDateFilterBuilder

參數

timeUnitsCount

number

時間單位數量

timeUnitType

RelativeDateFilterTimeUnit

定義篩選條件使用的時間單位

傳回

RelativeDateFilterBuilder

inNext(number, RelativeDateFilterTimeUnit)

將 inNext 設定為相對日期篩選的運算子

const relativeDateFilterBuilder = new RelativeDateFilterBuilder().inNext(timeUnitsCount, timeUnitType);

function inNext(timeUnitsCount: number, timeUnitType: RelativeDateFilterTimeUnit): RelativeDateFilterBuilder

參數

timeUnitsCount

number

時間單位數量

timeUnitType

RelativeDateFilterTimeUnit

定義篩選條件使用的時間單位

傳回

RelativeDateFilterBuilder

inThis(number, RelativeDateFilterTimeUnit)

將 inThis 設定為相對日期篩選條件的運算子

const relativeDateFilterBuilder = new RelativeDateFilterBuilder().inThis(timeUnitsCount, timeUnitType);

function inThis(timeUnitsCount: number, timeUnitType: RelativeDateFilterTimeUnit): RelativeDateFilterBuilder

參數

timeUnitsCount

number

時間單位數量

timeUnitType

RelativeDateFilterTimeUnit

定義篩選條件使用的時間單位

傳回

RelativeDateFilterBuilder

繼承的方法的詳細資料

withColumnAggregation(string, string, string)

使用數據行匯總目標物件設定篩選的目標屬性

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

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

參數

tableName

string

columnName

string

aggregationFunction

string

傳回

RelativeDateFilterBuilder

繼承自FilterBuilder.withColumnAggregation

withColumnTarget(string, string)

使用資料行目標物件設定篩選的目標屬性

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

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

參數

tableName

string

columnName

string

傳回

RelativeDateFilterBuilder

繼承自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): RelativeDateFilterBuilder

參數

tableName

string

hierarchy

string

hierarchyLevel

string

aggregationFunction

string

傳回

RelativeDateFilterBuilder

繼承自filterBuilder.withHierarchyLevelAggregationTarget

withHierarchyLevelTarget(string, string, string)

使用階層層級目標物件設定篩選的目標屬性

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

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

參數

tableName

string

hierarchy

string

hierarchyLevel

string

傳回

RelativeDateFilterBuilder

繼承自FilterBuilder.withHierarchyLevelTarget

withMeasureTarget(string, string)

使用量值目標物件設定篩選的目標屬性

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

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

參數

tableName

string

measure

string

傳回

RelativeDateFilterBuilder

繼承自FilterBuilder.withMeasureTarget

withTargetObject(IFilterTarget)

使用目標物件設定篩選的目標屬性

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

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

function withTargetObject(target: IFilterTarget): RelativeDateFilterBuilder

參數

target

IFilterTarget

傳回

RelativeDateFilterBuilder

繼承自FilterBuilder.withTargetObject