Client side sorting but server side filtering.

[Johan]

Hello Kendo forum.

I'm investigating the possibility to replace an older grid in our application to the Kendo Grid. The application is an n-tier MVC application and as the title says I would like sorting to happen client side without any postbacks (normal or ajax) and when the user changes the filter or paging I would like the grid to refresh with new data from the server. Can this be achieved, and if so, how?

I've been looking at the the grid.dataSource.serverSorting property but haven't been able to make it work. It also seems to only be available in the javascript setup and we would like to use the Html helper @(Html.Kendo().Grid() to setup the grid in order to get Razor syntax support.

I also noticed that the serverSorting, serverFiltering and serverPaging properties was available on the Kendo.Mvc.UI.DataSource type in the Controller but I'm not sure how to databind that to the grid and if it would work.

Thanks in advance.

[Petur Subev]

Hello Johan,

When using the Kendo MVC Extensions you can set ServerOperation to true or false and thus change all of the settings such as serverFiltering, serverPaging, serverGrouping, serverSorting to be performer either server side or client side - you cannot change just one or few of them.

Consider using the JavaScript version of the Grid if you want to separate the operations, also keep in mind that even if sorting is set to be executed on the client there will be an ajax request - if there is even one operation set to be server-side a ajax request will be performed.

Kind Regards,
Petur Subev
the Telerik team

[Shruthika]

Is this still true or any thing changed and explicit setting for serverFiltering, serverPaging, serverGrouping, serverSorting is exposed on kendo MVC Extensions?

[Shruthika]

Is this still true or any thing changed and explicit setting for serverFiltering, serverPaging, serverGrouping, serverSorting is exposed on kendo MVC Extensions?

[Nikolay Rusev]

Hello Shruthika,

 

There is a custom datasource  configuration exposed to MVC wrappers where you have fine grained control over which server operation is enabled.

 

Regards,
Nikolay Rusev
Telerik by Progress