Reset all setting DataGrid

[Krzysztof]

How can I reset via javascript the grid type filters sorting, paging, to the settings that occur immediately after opening the page

[Ajith Govarthan]

Hi Krzysztof, 

Greetings from syncfusion. 

Query: Need to reset all the settings of the grid. 

Based on the query we have prepared a sample in that we have initial filtering and sorting and we will be clearing when the grid loads. We have used the created event of the grid in that we have called the clearFiltering, clearSorting, and cleared the paging by calling the goToPage method. We have shared the sample for your reference. 

Index.js 

        allowPaging: true, 

        allowFiltering: true, 

        allowSorting: true, 

           sortSettings: { columns: [{ field: 'OrderID', direction: 'Ascending' }, { field: 'ShipCity', direction: 'Descending' }] }, // initial sorting 

        filterSettings: { type: 'Menu', columns: [{ field: 'ShipCity', matchCase: false, operator: 'startswith', predicate: 'and', value: 'reims' } // initial filtering  

       ] }, 

        created:function(args){ 

          debugger; 

          this.clearSorting(); 

          this.clearFiltering(); 

          this.goToPage(1); 

        } 

Sample: https://stackblitz.com/edit/z7sdyv-u1ynhc?file=index.js 

Please get back to us if you need further assistance. 

Regards, 

Ajith G. 

[Krzysztof]

It works very well. Thanks.

Can you also delete all grouping columns?

[Ajith Govarthan]

Hi Krzysztof, 

Thanks for your update. 

Query: Can you also delete all grouping columns? 

To clear the grouping we suggest you to use clearGrouping method of EJ2 Grid. This method will clear all the grouped columns.  

We have shared the sample for your reference. 

Code Snippet: 

Index.js 

        allowPaging: true, 

        allowFiltering: true, 

        allowSorting: true, 

          groupSettings: { columns: ['OrderDate'] }, 

        created:function(args){ 

          this.clearGrouping(); 

          this.groupModule.renderGroupDropArea(); 

        } 

Sample: https://stackblitz.com/edit/z7sdyv-aekzbn?file=index.js 

Documentation Link: https://ej2.syncfusion.com/documentation/api/grid/#cleargrouping 

Please get back to us if you need further assistance. 

Regards, 

Ajith G. 

[Krzysztof]

Thank you very much

[Ajith Govarthan]

Hi Krzysztof , 

We are happy to hear that your issue has been resolved. 

Please get back to us if you need further assistance 

Regards, 

Ajith G.