Remove applied filters from PivotGrid

[Heli Shah]

Hi,

I am developing Pivotgrid in Asp.Net MVC from reference demo solution.
I want to create one button, On click of that, I can able to remove all applied filters from PivotGrid using JavaScript.
Does anyone have any workaround on this?

[Dinesh Babu Yadav]

Hi Heli, 

 

Thanks for contacting Syncfusion support. 

 

We have analyzed your query and understand that you should clear the filters on click of button. You can clear the filterSettings on button click by clearing the same. Kindly find the following code snippet. 

 

Code snippet: [JavaScript] 

<script> 

 

    document.getElementById("element").addEventListener('click', function () { 

        var pivotObj = document.getElementById('PivotView').ej2_instances[0]; 

        pivotObj.dataSourceSettings.filterSettings = []; 

         

    }); 

 

</script> 

 

Meanwhile, we have prepared a sample for your reference. Please find the sample link below. 

 

Sample Link: https://www.syncfusion.com/downloads/support/forum/146019/ze/WebApplication1-2127032141 

 

Screenshots: 

Initial rendering 

 

 

After the button click: 

 

 

 

Please let us know if you have any concerns. 

 

Regards, 

Dinesh Babu Yadav