Custom Excel Style Grid Toolbar Item to Clear All Filters

[Levi Leonards]

I have an Excel Style Grid where every column can be filtered.

How can I create a Custom Toolbar Item to clear all of the filters on the grid and load the default data set?

[Pavithra Subramaniyam]

Hi Levi, 

We have analyzed your query and we have achieved your requirement by using CustomToolbarItem  property of ToolbarSettings and we  can clear the filtering using clearFiltering method of ejGrid control. Actions for this customized toolbar is defined in ToolbarClick event. Please refer the following code snippet, online document link and sample link . 

 

<ej:Grid ID="OrdersGrid" runat="server" AllowFiltering="True" AllowPaging="True" > 

<FilterSettings FilterType="Excel" />  

       <ClientSideEvents ToolbarClick="onToolBarClick" /> 

       <EditSettings AllowAdding="True" AllowDeleting="True" AllowEditing="True"></EditSettings> 

       <ToolbarSettings ShowToolbar="True"> 

                    <CustomToolbarItem> 

                        <ej:CustomToolbarItem Text="clearFilter" /> 

                    </CustomToolbarItem> 

       </ToolbarSettings> 

       <Columns> 

                  . . . 

       </Columns> 

</ej:Grid> 

    . . . 

<script type="text/javascript"> 

            function onToolBarClick(sender) { 

                if (sender.itemName == "clearFilter") 

                    this.clearFiltering(); 

            } 

</script> 

 

Online document link:   1. https://help.syncfusion.com/aspnet/grid/toolbar#custom-toolbar-items 

                                            2. https://help.syncfusion.com/api/js/ejgrid#methods:clearfiltering 

 

  Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/custom_toolbar-1824263622 

 

Regards, 

Pavithra S. 

[Levi Leonards]

Perfect example, thanks!

[Pavithra Subramaniyam]

Hi Levi, 

 

Thanks for your update.           

We are happy that the provided information helped you. 

 

Regards, 

Pavithra S.