Treetable with pagination and grouping

Webix JS
#1

I’m using a webix treetable with data loading from a server url with pagination. Server url loads 100 records per page with total_count as say 1000.

It works fine so far.

But if I apply grouping on a column, it’s throwing error. When I debug I understood that it’s failing because it’s trying to process 1000 records (based on the total_count) where as there are only 100 records loaded so far and throwing an error.

Is it possible to have grouping + remote pagination together on webix treetable.

Please check the sample code I’m using -

webix.ready(function () {
        var gridColumns = [{
            // ...
        }];

        var grid = webix.ui({
            container: "testA",
            view: "treetable",
            columns: gridColumns,
            url: "server-url.php"
            scheme: {
                $group: gridColumns[0].id
            },
            datafetch: 100,
            pager: {
                container: "paging_here",// the container where the pager controls will be placed into
                size: 100, // the number of records per a page
                group: 5   // the number of pages in the pager
            }
        });
    });

and the html is

<div id="testA" style='width:1200px; height:600px;'></div>
<div id="paging_here"></div>
#2

Data grouping is a client-side feature, so it won’t work when the data isn’t loaded completely. The only way is to group data (create a treestore-structure) at the server side and then load it dynamically.