How do I filter a widget data via embedding?

Published:

Bold BI supports to filter the data on a widget, even the dashboard is embedded into an application, using setFilterParameters() method. You can filter the data either by passing the values with column names or only the values.

Add the below code snippet based on your scenario, to achieve different levels of filtering on a widget.

Filtering data without column name

Single value:

var instance = BoldBI.getInstance("container"); // container -> embed container id
var widgetId = "2583540a-f970-41a1-9fc8-31c0581e7aa3";
var filtersValue = "Average"; // values to be filtered
var widgetInstance = instance.getWidgetInstance(widgetId).setFilterParameters(filtersValue);

Multiple values:

var instance = BoldBI.getInstance("container"); //container->embed container id
var widgetId = "2583540a-f970-41a1-9fc8-31c0581e7aa3";
var filtersValue = ["Average","Good"]; // values to be filtered
var widgetInstance = instance.getWidgetInstance(widgetId).setFilterParameters(filtersValue);

Filtering by one value without column name

Filtering by multiple values without column name

Filtering data with column name

Single column:

var instance = BoldBI.getInstance("dashboard"); // container -> embed container id
var widgetId = "2583540a-f970-41a1-9fc8-31c0581e7aa3";
var filtersValue = ["Department=Cardiology,Neurology"]; //Column name "Department" is passed
var widgetInstance = instance.getWidgetInstance(widgetId).setFilterParameters(filtersValue);

Multiple columns:

var instance = BoldBI.getInstance("dashboard"); // container -> embed container id
var widgetId = "2583540a-f970-41a1-9fc8-31c0581e7aa3";
var filtersValue = ["Department=Neurology","Name=Roony"]; //Different column names "Department" & "Name"
var widgetInstance = instance.getWidgetInstance(widgetId).setFilterParameters(filtersValue);