Grid Multi Column and Row Filtering

2 posts, 1 answers
  1. John
    John avatar
    5 posts
    Member since:
    Sep 2015

    Posted 08 Mar Link to this post

    Hello,

    I can get the multi filter to display or I can get the row filtering but I can't get both at once. My client is an excel experience heavy user and say the grid displays 700 records. They then want the ability to row filter and say that reduces it down to 350. Then they want to apply column value multi select filters to narrow the 350 down even further.

    However I have tried a couple different combinations and while they don't error out I don't get both filters on one grid.

    One attempt:

    @(Html.Kendo().Grid(Model)
            .Name("grid")
            .Columns(columns =>
            {
                columns.Bound(e => e.A).Filterable(ftb => ftb.Multi(true).Search(true));
                columns.Bound(e => e.B).Filterable(ftb => ftb.Multi(true).Search(true));
                columns.Bound(e => e.C).Filterable(ftb => ftb.Multi(true).Search(true));
                columns.Bound(e => e.D).Filterable(ftb => ftb.Multi(true).Search(true));
                columns.Bound(e => e.E).Filterable(ftb => ftb.Multi(true).Search(true));
            })
            .HtmlAttributes(new { style = "width: 80%;" })
            .DataSource(data => data.Ajax().Model(mdl => mdl.Id(p => p.A) ))
            .Scrollable()
            .Groupable()
            .Sortable()
            .Editable()
            .Filterable(ftb => ftb.Mode(GridFilterMode.Row))
            .Resizable(size => size.Columns(true))
            .Selectable(selectable => selectable.Mode(GridSelectionMode.Multiple))
            .Pageable(pageable => pageable
                .Refresh(true)
                .PageSizes(true)
                .ButtonCount(5))
            )

     

    Another attempt:

    @(Html.Kendo().Grid(Model)
            .Name("grid")
            .Columns(columns =>
            {
                columns.Bound(e => e.A).Filterable(ftb => ftb.Multi(true).Search(true)).Filterable(ftb => ftb.Mode(GridFilterMode.Row));
                columns.Bound(e => e.B).Filterable(ftb => ftb.Multi(true).Search(true));
                columns.Bound(e => e.C).Filterable(ftb => ftb.Multi(true).Search(true));
                columns.Bound(e => e.D).Filterable(ftb => ftb.Multi(true).Search(true));
                columns.Bound(e => e.E).Filterable(ftb => ftb.Multi(true).Search(true));
            })
            .HtmlAttributes(new { style = "width: 80%;" })
            .DataSource(data => data.Ajax().Model(mdl => mdl.Id(p => p.A) ))
            .Scrollable()
            .Groupable()
            .Sortable()
            .Editable()
            .Filterable()
            .Resizable(size => size.Columns(true))
            .Selectable(selectable => selectable.Mode(GridSelectionMode.Multiple))
            .Pageable(pageable => pageable
                .Refresh(true)
                .PageSizes(true)
                .ButtonCount(5))
            )

     

    Thoughts?

    JB

  2. Answer
    Boyan Dimitrov
    Admin
    Boyan Dimitrov avatar
    1746 posts

    Posted 10 Mar Link to this post

    Hello John,

     

    I am afraid that due to the design concept of the filter row model it does not allow multi filter check box. What I can suggest you is to define a Kendo UI MultiSelect widget as a filter widget for a specific column in order to achieve multiple selection filtering. Please refer to the http://dojo.telerik.com/ilaHa example.  

     

    Regards,
    Boyan Dimitrov
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. UI for ASP.NET MVC is VS 2017 Ready
Back to Top