How to get Filter Column and FilterValue from code behind radgrid

 Here I am going to explain how to get list of filtered columns including filter value from code behind in telerik radgrid.

 The below tutorial helps us to get list of filtered values from telerik radgrid. For reports we are able to save the filtered values in database and also we can apply when next time we opening the report grid

      

XElement docFilters = new XElement("Filters");

string FilterValues = "";

int j = 0;

foreach (GridTableView.PersistableColumnSetting filter in radgrid.MasterTableView.ColumnSettings)

{

    if (filter.ListOfFilterValues != null)

    {

        string filterColumn = filter.UniqueName;

        foreach (string FilterValue in filter.ListOfFilterValues)

        {

            if (j != 0)

            {

                FilterValues = FilterValues + "," + FilterValue;

            }

            else

            {

                FilterValues = FilterValue;

            }

            j++;

        }

        XElement XelFilter = new XElement("Filter");

        XelFilter.Add(

                   new XElement("ColumnName", filterColumn),

                   new XElement("Values", FilterValues));

        docFilters.Add(XelFilter);

        FilterValues = "";

    }

    

}

Remove Column from Column menu Telerik Radgrid

 <script>

    function OnHeaderMenuShowing(sender, args) {

        var menu = args.get_menu(); //  Gets the RadContextMenu object

        var radMenuItem = menu.findItemByText("Columns");   //  Gets the Columns RadMenuItem Object

        var radMenuItemCollection = radMenuItem.get_items();    //  Gets the Collection of Items in the Columns Object

        //  Iterate the Collection

       for (var i = 0; i < radMenuItemCollection.get_count() ; i++) {

            // Do Some Logic to Hide the Item

            if (radMenuItemCollection.getItem(i).get_text() === "DocId")

                {

                radMenuItemCollection.getItem(i).set_visible(false);

            }

        }

    }

        </script>