Access and determine applied filters

RELATED TO:

AUTHOR: Eyup Yusein

DATE POSTED: June 28, 2019


DESCRIPTION

RadPivotGrid provides built-in Includes/Excludes filtering. After the user filters the pivotgrid content, you may want to be able to get this information for indication or other reasons.

SOLUTION

You can use the following approach to achieve this requirement:
bool isFiltered = false;
protected void RadPivotGrid1_ItemCommand(object sender, PivotGridCommandEventArgs e)
{
    if (e.CommandName == RadGrid.FilterCommandName)
    {
        isFiltered = true;
    }
}
protected void RadPivotGrid1_PreRender(object sender, EventArgs e)
{
    if (isFiltered)
    {
        PivotGridFiltersCollection filters = RadPivotGrid1.Filters;
        StringBuilder sb = new StringBuilder("<br/><b>Currently applied filters:</b><br/>");
        foreach (PivotGridLabelGroupFilter filter in filters.OfType<PivotGridLabelGroupFilter>())
        {
            string colName = filter.FieldName;
            PivotGridSetCondition condition = filter.Condition as PivotGridSetCondition;
            sb.Append(colName + ": " + condition.Comparison + " - "
                + string.Join(", ", condition.Items.Select(x => x.ToString())) + "<br/>");
        }
        Label1.Text = sb.ToString();
    }
}

More Resources

  • Forums

    Find answers to thousands of questions or reach out to our active community.

  • Demos

    Browse 1,200+ demos with source code covering basic and advanced scenarios.

  • Sample Applications

    Learn how to integrate the controls in real-world examples.

  • Feedback Portal

    Vote and follow the features you want to see added to Telerik UI for ASP.NET AJAX.

  • User Voice

    Get answers directly from the people who build the product.

  • Documentation

    Benefit from detailed help articles and API references for all controls.

  • Knowledge Base

    Learn how to achieve common scenarios from a multitude of tutorials and working examples.

  • Code Library

    Browse sample projects submitted by Telerik staff and community members.

  • Blog

    Stay up-to-date with the latest functionality, how-to articles and industry trends.

  • Release History

    Up-to-date release notes for all new features and improvements.