Display Filtered Records

[Dongzhi]

I have a scenario where I have a grid with 20 columns. When the user filters on any columns of the I want a label to display which columns are filtered. How can I do that in the grid? I tried using the Filtered event but got stuck:

        protected void TelerikGridFiltered(object sender, GridViewFilteredEventArgs e)
        {
            filterRecordText.Text = e.ColumnFilterDescriptor.Column.Name;
        }

[Dimitrina]

Hello,

The Filtered event should be raised every time the user applies filtering on any column. Then all the information on the applied filtering criteria is available through RadGridView.FilterDescriptors collection.
Would you please share some more details on what do you mean as you say that you get stuck?

Regards,
Dimitrina
Telerik

 

 

[Dongzhi]

I don't know how loop through the FilterDescriptors collection for the filtered column names and display them to the user.

[Dimitrina]

Hello,

You could extract the data and populate it as a Text for the defined TextBlock similar to:

private void clubsGrid_Filtered(object sender, GridViewFilteredEventArgs e)
{
    if (clubsGrid.FilterDescriptors.Count == 0)
    {
        filteredText.Text = string.Empty;
        return;
    }
    MemberColumnFilterDescriptor desc = clubsGrid.FilterDescriptors[clubsGrid.FilterDescriptors.Count - 1] as MemberColumnFilterDescriptor;
    filteredText.Text += desc.Member + " ";
}

How does this work for you?

Regards,
Dimitrina
Telerik

 

 

[Dongzhi]

Yes this worked for however I made a few minor changes so I wouldn't get redundant filter names when the user filters the same column using the checkboxes.

var finaldesc = grid.FilterDescriptors;
this.filterRecordText.Text = string.Empty;

            if (grid.FilterDescriptors.Count != 0)
            {
                foreach (var filterMember in finaldesc)
                {
                    var desc = filterMember as MemberColumnFilterDescriptor;
                    this.filterRecordText.Text += desc.Member + " ";
                }
            }