nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Clear filters on table using clearFilters()

divyani

Hi,
 
I have a pie chart in my report which shows number of customers per country. I also have a table which lists down the customers. Now, i wrote script in Y-series-mouse click event to filter the data in the table whenever a pie slice is clicked. For eg, if user clicks on "France" pie slice, the table must show only the list of customers in France.
 
I also a have a html button in the report using which i am trying to clear the filters applied on the table. When i say table.clearFilters("COUNTRY"), it says "Invalid Column Name[Country]".
 
P.S: However, If I am writing a script to set the filters using the same html button then it is working.
 
Attached is the sample report. Thanks in advance!

Find more posts tagged with

Comments

Clement Wong

I will determine if it's a defect, but for now the workaround to copy the [COUNTRY] from the group to the detail (right below is OK). Then change Visibility of the new [COUNTRY] data item to â€œHide Elementâ€ for all outputs.
 
Attached is the updated design where the "Reset" button is working in my iHub 3.1 environment.