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

[Marco57]

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.

[V-lianl-msft]

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-fil... 

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

[Marco57]

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.