Forum Discussion

adeepak7's avatar
adeepak7
Frequent Visitor
7 years ago

2 targets for host.applyJsonFilter

Respected Amin,

 

I am using the following code snippet:

 

const target = {
//Table name
table: this.column[0].queryName.substr(0, this.column[0].queryName.indexOf('.')),

//First field in the table which we want to apply filter on:
column: this.column[0].queryName.substr(this.column[0].queryName.indexOf('.') + 1)
};

//Checking for the name.
console.log("Table: " + target.table + "\nColumn: " + target.column);

let filter = new models.AdvancedFilter(
target,
"And",
{
operator: "Is",
value: text
}
);
let action = FilterAction.merge;
this.searchBox[0].value = text;

this.host.applyJsonFilter(filter, "general", "filter", action);

I want to apply filter on the table for 2 columns. That means I will have to use an API that takes 2 targets and filter as arguments.

 

Is there any solution available for this usecase? In short, I want to apply filter on 2 columns of same table.