This is a migrated thread and some comments may be shown as answers.

Multi-check filter on dimensions

1 Answer 40 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Fernando
Top achievements
Rank 1
Fernando asked on 08 Feb 2017, 06:36 PM

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
                            .Multi(true)
                            .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 }))));
                        bounded.Width(300);
                    }

 

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.

 

1 Answer, 1 is accepted

Sort by
0
Angel Petrov
Telerik team
answered on 10 Feb 2017, 01:48 PM
Hi,

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.

Regards,
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.
Tags
PivotGrid
Asked by
Fernando
Top achievements
Rank 1
Answers by
Angel Petrov
Telerik team
Share this question
or