Multi-check filter on dimensions

2 posts, 0 answers
  1. Fernando
    Fernando avatar
    1 posts
    Member since:
    Oct 2013

    Posted 08 Feb 2017 Link to this post

    Hi people.

    I'm implementing PivotGrid on my ASP.NET MVC application. With the Grid component, I was able to make filters based on a selection of which values I want due to bounded columns capture feature.

    Is there something like this on PivotGrid?

    In Grid component. I've done the filter just like this:

                        var bounded = gridColumns.Bound(dataTableCol.GetType(), dataTableCol.ToString());
                        // If the column has a multicheckbox filter - set it based on column definition
                        var customFilterColumn = Model.columns.SingleOrDefault(item => item.ColumnName.Equals(dataTableCol.ToString()));
                        if (customFilterColumn != null)
                            bounded.Filterable(ftb => ftb
                                .Cell(cell =>
                                cell.DataSource(ds =>
                                    // This is the action that will return the filter unique values
                                    ds.Read("MultiFilter_read", "Consulta", new { columnId = customFilterColumn.Id }))));


    In "Consulta/MultiFilter_read" action I make a search on database returning the possible values for that column, applying them to the respective bounded column. This instructions I've put on Columns property of the Grid HtmlHelper, and I'm doing PivotGrid with HtmlHelpers too.


  2. Angel Petrov
    Angel Petrov avatar
    1053 posts

    Posted 10 Feb 2017 Link to this post


    I am sorry to say but the current implementation of the pivot does not expose such means. That said I suggest logging a feature request in our feedback portal. That way our developers will be able to examine the matter and if possible improve the functionality for a future release.

    Angel Petrov
    Telerik by Progress
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top