Grouping & sorting when using OData

[Anton]

Hello

I'm using OData as a backend service and of course I use server sorting, paging and filtering in my data source config, but server groupping is not supported, so I can't use it. The problem happens when I use sorting + grouping. Results are not sorted inside of the group. 

How can this be fixed?

Thanks

[Tsvetina]

Hello Anton,

This is expected behavior because grouping functionality needs sorting to be applied to display sorted results in the group. However, the DataSource cannot perform sorting on the client-side (because of the serverSorting setting). That is why the documentation advises on applying all data operations either on the server side or on the client side.
You can enable client sorting (which may trigger undesired results with paging), switch all operations to client mode or leave the groups like this if the unsorted information is at least the correct set of data that needs to be displayed.

Regards,
Tsvetina
Progress Telerik

[Anton]

Hi Tsvetina,

Ok, got it.

Thanks

[Anton]

Hi guys, I wanted to keep OData very much, so come up with some trick for solving this, described here: http://tsherlock.tech/2017/09/30/kendo-grid-workaround-for-client-side-groupping/ Hope it will be useful for someone else. Thanks.