Grouping With Pagination Only Shows Groups On The First Page

[Ning]

Hi,

In my kendo ui grid, my data volume is between 1000 to 9000, and I used pagination to speed up performace. Without pagination, it's extremely slow, impossible ot use. However, when I group by some column, only the groups in the first page will be displayed. If the first group spans over multiple pages, then when I collapse the group, I can only see one group in the first page, instead of all the groupings I have. I saw that this issue was raised in 2014, 2015. I am wondering if this issue has been addressed? What's the workaround for it?  

Thanks,

Ning

[Dimiter Topalov]

Hello Ning,

This is the expected behavior of the Kendo UI Grid, as paging is always performed before grouping to avoid unnecessary grouping of the whole dataSource. The desired behavior is not supported, but can be achieved with some custom logic.

As there are no special events, associated with the expanding and collapsing, the developer needs to handle the click events of the collapse/expand icons (they have classes .k-icon.k-i-collapse ​and .k-icon.k-i-expand respectively), and change the dataSource.pageSize with the desired value.

Also the groups in view have to be expanded/collapsed programmatically if needed, as demonstrated in the following how-to article:

http://docs.telerik.com/kendo-ui/controls/data-management/grid/how-to/persist-grouped-grid-collapsed-details-state

Let us know if you have other questions about Kendo UI.

Regards,
Dimiter Topalov
Telerik

[ICT]

Hi Dimiter,

 

Could you please elaborate further as to how this desired behavior can be achieved?

[Stefan]

Hello,

After inspecting the scenario, this will require having no initial paging before the grouping. This is required because as my colleague said the paging is done before the grouping which will lead to the scenario where the actual number of records will not be available for the calculation to determine the new page size.

In this scenario with grouping and a large data set, we can recommend our new endless scrolling feature. Its specific implementation will ensure that all records in a group will be displayed together: 

https://docs.telerik.com/kendo-ui/controls/data-management/grid/appearance#endless-scrolling

http://demos.telerik.com/kendo-ui/grid/endless-scrolling-local

I hope this helps.

Regards,
Stefan
Progress Telerik

[Vladimir]

I have the very same problem with Kendo for angular 2+ - is there some solution already or also here is it remaining paging first, then grouping - and like before - grouping of only the current page? ...

[Svet]

Hi Vladimir,

Indeed, the Kendo UI for Angular Grid performs paging first and then grouping. What I can recommend is to use the GroupBindingDirective which allows to use virtualization with grouping as demonstrated in the following article:

https://www.telerik.com/kendo-angular-ui/components/grid/scroll-modes/virtual/#toc-using-virtualization-with-grouping

I hope this helps.

Regards,
Svetlin
Progress Telerik