We are loading grid all at one time and using DHTMLX provided paging.
When we do group by, group by seems to apply to only the current page but not other pages.
Group by should apply to all the data not just current page.
What is the solution?
there is no server side dynamic loading and no smart rendering.
This is known limitation. gropBy() is incompatible with paging.
So group by only works when we display all the the data in one page.
I can understand it not working with server side paging as grid does not have all the data, but it should work with client side paging as client has all the data.
Any plans to fix this.
groupBy() method requiere all row to be rendered.
As a work around you may try to use dhtmlxTreeGrid