Kendo grid filtering

[PAUL]

Telerik had an attribute for the rad_grids called AllowFilteringByColumn="true" which allowed us to filter the records by criteria entered in the textboxes or datepickers at the top of the grid.

Does Kendo do this and is there an example?

All I found in documentation is adding Filterable to the columns which takes true or false. Nothing else and it doesn't do anything.

The other was setting the grid to Filterable which takes no arguments and does nothing so I have no idea...

Thanks for your help...

Paul

[Vladimir Iliev]

Hi Paul, 


You can enable the filtering UI of Grid with .Filterable() method in the Grid definition:

e.g.:

@(Html.Kendo().Grid<Kendo.Mvc.Examples.Models.ProductViewModel>()
    .Name("Grid")
    .Columns(columns => {
        columns.Bound(p => p.ProductName);
        columns.Bound(p => p.UnitPrice).Width(140);
        columns.Bound(p => p.UnitsInStock).Width(140);
        columns.Bound(p => p.Discontinued).Width(100);
        columns.Command(command => { command.Edit(); command.Destroy(); }).Width(200);
    })
    .Filterable()

 Also please note that after enabling filtering UI of the Grid each column by default is set to .Filterable(true). You can chage the dafault setting and make it not filterable by .Filterable(false):

    columns.Bound(p => p.UnitPrice).Width(140); //Filtering enabled on this column by dafault
    columns.Bound(p => p.UnitsInStock).Width(140).Filterable(false); //Filtering disbled on this column
    columns.Bound(p => p.Discontinued).Width(100).Filterable(false); //Filtering disbled on this column
})
.Filterable()

Please note that with your KendoUI for ASP.NET MVC installation comes offline demos which cointains example of Grid filtering (please see attached screenshot). These demos usually are located in:

• ..\Telerik\Kendo UI for ASP.NET MVC %VERSION%\wrappers\aspnetmvc\Examples

Kind Regards,
Vladimir Iliev
the Telerik team

[PAUL]

Hello Vladimer,

Thanks for reply. The screen shot is exactly what I want to do with the filtering of columns. I will look in the examples and see what I can find out.

Thank you

Paul