RadGrid Clear Filters

[Chamara]

[fb]

I have a telerik RadGrid with AutoGenerateColumns-AtRuntime=true.i need to clear the filters in the radgrid on a button click.i have the following code which is not working   foreach (GridColumn column in  gridSearchL3.MasterTableView.OwnerGrid.Columns)         {             column.CurrentFilterFunction = GridKnownFunction.NoFilter;             column.CurrentFilterValue = string.Empty;         }           gridSearchL3.MasterTableView.FilterExpression = string.Empty; please help.

[Jayesh Goyani]

Hello,

<telerik:RadGrid ID="RadGrid2" runat="server" AutoGenerateColumns="true" AllowFilteringByColumn="true">
             OnNeedDataSource="RadGrid2_NeedDataSource"
        </telerik:RadGrid>

 <asp:Button ID="Button1" runat="server" Text="clear filter" OnClick="Button1_Click" />

void RadGrid2_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
   {
       dynamic data = new[] {
               new { ID1 = 1, ID2 = 2, ID3=3},
               new { ID1 = 4, ID2 = 5, ID3=6}

           };
       RadGrid2.DataSource = data;
   }

void Button1_Click(object sender, EventArgs e)
    {
        foreach (GridColumn column in RadGrid2.MasterTableView.OwnerGrid.Columns)
        {
            column.CurrentFilterFunction = GridKnownFunction.NoFilter;
            column.CurrentFilterValue = string.Empty;
        }
        RadGrid2.MasterTableView.FilterExpression = string.Empty;
        RadGrid2.Rebind();
    }

Note : after remove filter expression we must have to re assign datasource and bind it.

Thanks,
Jayesh Goyani

[Chamara]

when the grid is rendered there are nearly 10 auto generated columns in the grid.but when i run the following code and use a breakpoint, it shows the column count as 2 (RadGrid2.MasterTableView.OwnerGrid.Columns). why is it not getting the autogenerated columns.because of this filters are not cleared

foreach (GridColumn column in RadGrid2.MasterTableView.OwnerGrid.Columns)

        {

            column.CurrentFilterFunction = GridKnownFunction.NoFilter;

            column.CurrentFilterValue = string.Empty;

        }

following is my radgrid

 <telerik:RadGrid ID="gridSearchL3" runat="server" AllowPagg="True" AutoGenerateColumns="true"  
             GridLines="None" Skin="Office2007" Height="415px" 
             OnExcelMLExportRowCreated="gridSearchL3_ExcelMLExportRowCreated" OnExcelMLExportStylesCreated="gridSearchL3_ExcelMLExportStylesCreated"
            OnGridExporting="gridSearchL3_GridExporting"  oninit="gridSearchL3_Init" OnNeedDataSource="RadGrid1_NeedDataSource"
            Font-Names="Eras Medium ITC" Font-Size="Small" PageSize="50" 
             AllowFilteringByColumn="True" onitemcreated="gridSearchL3_ItemCreated" 
            
             onselectedindexchanged="gridSearchL3_SelectedIndexChanged" 
             AllowSorting="True" ShowStatusBar="True" AllowPaging="True">
               <FilterItemStyle Font-Names="Eras Medium ITC" Font-Size="XX-Small" />
               <GroupingSettings CaseSensitive="False" />
            <ExportSettings Excel-Format="ExcelML" ExportOnlyData="True" 
                FileName="PinC Group" IgnorePaging="True" OpenInNewWindow="True">
                <Excel Format="ExcelML" />
            </ExportSettings>
            <ClientSettings>
                <ClientEvents OnRowClick="onRowClick" OnRowSelected="RowSelected" />
                <Selecting AllowRowSelect="True" />
                <Scrolling AllowScroll="True" UseStaticHeaders="True" />
            </ClientSettings>
            <AlternatingItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            <GroupHeaderItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            <SortingSettings EnableSkinSortStyles="false" /> 
            <MasterTableView ClientDataKeyNames="Document #,Revision,hID,ID" Font-Names="Eras Medium ITC" 
                   Font-Size="X-Small">
           
                <CommandItemSettings ExportToPdfText="Export to Pdf" />


                <Columns>


                    <telerik:GridTemplateColumn AllowFiltering="false" UniqueName="template" >
                        <ItemTemplate>
                            <asp:CheckBox ID="CheckBox1" runat="server" OnCheckedChanged="ToggleRowSelection" AutoPostBack="true"/>
                        </ItemTemplate>
                        <HeaderTemplate>
                            <asp:CheckBox ID="CheckBoxHeader" OnCheckedChanged="Header_checkedChange" runat="server" AutoPostBack="true"/>
                        </HeaderTemplate>
                    </telerik:GridTemplateColumn>
                
                    <telerik:GridButtonColumn  Text="View" CommandName="Select" UniqueName="LinkColumn"></telerik:GridButtonColumn>
                
                </Columns>
                <ItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
                <PagerStyle Mode="NextPrevNumericAndAdvanced" />
                <FilterItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            </MasterTableView>
            <EditItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            <FooterStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            <HeaderStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            <FilterItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
               <CommandItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
               <ActiveItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
               <ItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
               <PagerStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" 
                   HorizontalAlign="Left" Mode="NextPrevNumericAndAdvanced" />
               <SelectedItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
               <FilterMenu Font-Names="Eras Medium ITC" Font-Size="X-Small" 
                Skin="Office2007" EnableRoundedCorners="True">
               </FilterMenu>
               <HeaderContextMenu Font-Names="Eras Medium ITC" Font-Size="X-Small" 
                   Skin="Simple">
               </HeaderContextMenu>
               </telerik:RadGrid>

[Jayesh Goyani]

Hello,

try with below code snippet.

foreach (GridColumn column in RadGrid2.MasterTableView.Columns)
//foreach (GridColumn column in RadGrid2.MasterTableView.AutoGeneratedColumns)


        {

            column.CurrentFilterFunction = GridKnownFunction.NoFilter;

            column.CurrentFilterValue = string.Empty;

        }

Note : try this code with page_prerener or grid_prerender Event.

Thanks,
Jayesh Goyani

[Chamara]

hi!
thanx for the reply.still no luck.tried adding the code in to both events.still it gets the column count as 2

[Jayesh Goyani]

Hello,

let me know "RadGrid2.MasterTableView.AutoGeneratedColumns" working or not ?

Thanks,
Jayesh Goyani

[Chamara]

hi jayesh!

got it working.thanx for u'r help.working code is as follows

 foreach (GridColumn column in gridSearchL3.MasterTableView.AutoGeneratedColumns)
        {
            column.CurrentFilterFunction = GridKnownFunction.NoFilter;
            column.CurrentFilterValue = string.Empty;
        }

[Amrit]

<

 

 

tr align="right">

 

 

 

    <td>

 

 

 

        <a href="YourPageName.aspx">Reset Filters</a>

 

 

 

    </td>

 

 

 

</tr>

 

[Calvin]

Dear Sir,

The above function works well for standard filter, how about clearing the checkbox filter?

Thanks.

[Jayesh Goyani]

Hello Calvin,

Is your issue was resolved?

Thanks,
Jayesh Goyani

[Calvin]

Yes. It is resolved.

Thanks.

[Salman]

I am unable to find 

Gird.masterTableView

[Salman]

solved:

Found some thing regarding telerik Rad gridview Filtering in windows form application I was trying to Remove All filters from radgridview and after a hectic day I found it my self to remove all filters

if(radgridView1.filterDiscriptor.count>0)
{
radgridView1.filterDiscriptor.clear();
}

or

foreach(telerik.windows.data.filterDiscriptor
fdObejct in radgridview1.filterDiscriptor)
{
fdObject.value=string.empty;
}

[Eyup]

Hi Salman,

The following approach should work for clearing the grid filters:

foreach (GridColumn column in RadGrid2.MasterTableView.OwnerGrid.Columns)
{
    column.CurrentFilterFunction = GridKnownFunction.NoFilter;
    column.CurrentFilterValue = string.Empty;
}
RadGrid2.MasterTableView.FilterExpression = string.Empty;
RadGrid2.Rebind();

These code snippets are applicable to RadGrid control from the Telerik toolkit for ASP.NET AJAX. If you are using another grid control, you should direct your queries in the respective forum section for the technology in question:
http://www.telerik.com/forums/winforms/gridview

Regards,
Eyup
Telerik

[Urshela]

how do i clear a specific filterexpression but i have 3 columns on my grid 2 textboxes and one dropdown. I have filter all not i want to clear only the dropdown on a button here my code but its not working 

 foreach (GridColumn column in InvoiceItemDisplayGrid.MasterTableView.RenderColumns)
                {
                    if (column is GridBoundColumn)
                    {
                        GridBoundColumn boundColumn = column as GridBoundColumn;
                        if (boundColumn.DataField.Equals("ConsignorName"))
                        {
                            boundColumn.CurrentFilterFunction = GridKnownFunction.NoFilter;
                            boundColumn.CurrentFilterValue = string.Empty;
                            InvoiceItemDisplayGrid.MasterTableView.Rebind();
                            InvoiceItemDisplayGrid.Rebind();
                            var filterExpression = InvoiceItemDisplayGrid.MasterTableView.FilterExpression.Replace(".ToString()", String.Empty);

                            InvoiceItemDisplayGrid.MasterTableView.FilterExpression = filterExpression;
                            InvoiceItemDisplayGrid.Rebind();
                        }
                    }
                }

[Eyup]

Hi Chamara,

Please try to use the RenderColumns collection instead as demonstrated in the attached web site samples.

Regards,
Eyup
Telerik

[Vinit]

Both the examples attached are clearing all the filters unlike what the user is asking. I also have a checkbox filter which load with default value of nothing checked, but when it is checked it returns only True filter values. But when unchecked it returns False values only.

 Task Title | Is Allocated

Task 1 | True

Task 2 | True

Task 3 | False

Task 4 | False

 

Default view is All rows.

When Check box checked:(Expected)

 Task Title | Is Allocated
Task 1 | True
Task 2 | True

 When Checkbox unchecked (Not correct)

 Task Title | Is Allocated
Task ​3 | ​False

Task ​4 | False

 I have code similar to the previous poster and have explicitly cleared the checkbox by using the Column Collections.
 Unsure how we can clear only specific column filters and not all filters.

[Eyup]

Hi Vinit,

You can initiate a filter command with NoFilter function to clear the applied filtering of a single column:
http://www.telerik.com/forums/radgrid-enable-filter-code-behind#cel1slcp-U-pmV28CfXTrg

Hope this helps. Please give it a try and let me know if it works for you.

Regards,
Eyup
Telerik

[Salim]

Hi, 

When I apply a filter to a column, the column become Yellow. 

When I reset the filter, the filter is reset but the column color remain yellow. 

How can reset the color also ? 

Thanks

[Eyup]

Hello,

Please try traversing the MasterTableView.RenderColumns or MasterTableView.AutoGeneratedColumns instead and let me know about the result.

Regards,
Eyup
Telerik

[Salim]

Thanks but MasterTableView.RenderColumns and MasterTableView.AutoGeneratedColumns don't work

[Eyup]

Hello Salim,

Please download and run the RadGridFilterClearAll.zip and RadGridFilterClearFromClient.zip samples provided in one of my previous posts and let me know about the result.

Regards,
Eyup
Telerik

[Raymond]

The GridColumn Object has a method called ResetCurrentFilterValue.  The popup hint for that function says that it "Resets the values of the GridColumn.CurrentFilterFunction, GridColumnCurrentFilterValue, GridColumn.AndCurrentFilterFunction and GridColumn.AndCUrrentFilterValue properties to their defaults".  See attached image.

 

It does appear to reset the value, but not the function as the popup hint states. 

 

[Eyup]

Hi Raymond,

 

In this case you can set the CurrentFilterFunction manually to NoFilter. The best way to clear the filters of the grid is this approach:
https://www.telerik.com/support/kb/aspnet-ajax/grid/details/reset-radgrid-state


I hope this will prove helpful.

Regards,
Eyup
Progress Telerik