I am busy doing a POC to figure out if Kendo Web Grid will fulfill all our requirements for a grid. I am currently stuck with server side grouping.
Please can I ask for some clarity on how to handle the response from the server for grouping.
The grid is not grouped by default, but they can choose to group by any of the columns..one or more..so the response needs to know this as well.
We are using the HTML/Js version of the grid with Ruby on Rails.
Our data is created from a backend query that is formatted into json.
eg: of our response with no grouping :
{"items":[{"countries":{"name":"South Africa","iso_alpha_2":"ZA","iso_alpha_3":"ZAF"}},...
The grid is initialized like this
dataGrid.kendoGrid({
dataSource: data_source,
groupable: true,
sortable: true,
pageable: {
refresh: true
},
columns: [
#{columns_json}
]
});
and our Datasource like this:
data_source = new kendo.data.DataSource({
transport: {
read: {
url: "#{data_table.url}",
dataType: "json"
},
parameterMap: function (options, operation) {
return options;
}
},
batch: true,
pageSize: 10,
serverGrouping: true,
serverPaging: true,
schema: {
data: function(response){
if (response.items) {
return response.items;
} else return null;
},
total: function (response) {
if (response.items)
return response.total_count;
else
return 0;
}
}
});
How must the server response be formatted if a person has grouped by a column? I am assuming the response format is different if it is grouped compared to if it isn't...how can that scenario be easily handled as well?
I hope I am clear in my request.
3 Answers, 1 is accepted
The server response format for serverGrouping is explained here:
Please check the article and let me know if you have any further questions.
Regards,
Alexander Valchev
Telerik
Rank 1
Hi
First of all sorry to conflict this thread.
I found ToDataSourceResult source code in https://github.com/kendo-labs/dlinq-helpers/blob/master/Kendo.DynamicLinq/QueryableExtensions.cs this location. But it looks like very old. Could you please update this source code with the latest for better understanding about ToDataSourceResult?
Hi, Andrew,
The code that you have found is not part of the Kendo.Mvc.dll and the Queryable extensions. They are a community effort and largely experimental as noted in the README.md
The ToDataSourceResult() extension method is designed to work with the built-in transports in ASP.NET MVC & ASP.NET Core and the source code is available in the accounts of licenced users when they navigate to the Downloads section.
It appears that you are testing out the jQuery Kendo UI Grid and using of the server-side extensions is not required. You can format your own response and structure the grid data source in such way that it can parse it.
We have a runnable example in a sample Knowledge Base that can help you format the group response here:
https://docs.telerik.com/kendo-ui/knowledge-base/grid-format-of-the-response-with-server-grouping
On the other hand, there are developers who prefer to use JavaScript to build their grids but like to benefit from the server data and aggregation conducted in one line of code in their controllers, so they can use the MVC extensions with a built-in data source transport, for example:
"dataSource": {
"type": "aspnetmvc-ajax",
Here is another forum post that shows that:
Let us know in case you have further questions.
Kind Regards,
Alex Hajigeorgieva
Progress Telerik