topic Re: BUG API Javascript Property 'table' does not exist on type 'IFilterGeneralTarget' in Developer

BUG API Javascript Property 'table' does not exist on type 'IFilterGeneralTarget'

Marco57 — Tue, 09 Feb 2021 23:59:44 GMT

Hello,

I am calling on power bi client javascript library :

let newState: pbi.models.IAdvancedFilter;

on the interfaces, this library states that it extends IFilter interface:

IFilter interface has a key called "target": of type IFilterGeneralTarget

IFilterGeneralTarget can be of type IFilterTarget:

IFilterTarget can be of type IFilterColumnTarget:

IFilterColumnTarget finally has a key "column":

now the issue is why am I getting that my variable can't have a "column" key ?!:

Many thanks in advance for any support.

Rgds, Marc.

Re: BUG API Javascript Property 'table' does not exist on type 'IFilterGeneralTarget'

V-lianl-msft — Fri, 12 Feb 2021 02:23:30 GMT

Hi Marco57 ,

See if these will help:

https://docs.microsoft.com/en-us/javascript/api/overview/powerbi/targets

https://docs.microsoft.com/en-us/javascript/api/overview/powerbi/control-report-filters#advanced-filter

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: BUG API Javascript Property 'table' does not exist on type 'IFilterGeneralTarget'

Marco57 — Fri, 12 Feb 2021 17:32:35 GMT

Hi V-lianl-msft

This is the issue I have, I define an empty advanced filter :

slicerStateBetween: <pbi.models.IAdvancedFilter>{ $schema: "http://powerbi.com/product/schema#advanced", conditions: [ { operator: "GreaterThanOrEqual", value: null }, { operator: "LessThanOrEqual", value: null }], filterType: 0, logicalOperator: "And", target: { column: "", table: "", } }

I copy it into another variable :

let newState: pbi.models.IAdvancedFilter; newState = this.reportAssets.slicer.slicerStateBetween; newState.target.column = currentFilter.filter.NAME;

There is hwere the error happen, I can't assign attribute column to target even if newState is of type IAdvancedFilter and as per documentation it contains target and column key inside of it:

const advancedFilter = { $schema: "http://powerbi.com/product/schema#advanced", target: { table: "Store", column: "Name" }, logicalOperator: "Or", conditions: [ { operator: "Contains", value: "Wash" }, { operator: "Contains", value: "Park" } ], filterType: models.FilterType.AdvancedFilter }

thanks.