Dynamic loading sort

Webix JS
1

I have dynamic loading working (Helga, thank you for your earlier help). But I am seeing some unexpected behavior.

It is setup as: using PHP Data Connector, dynamic loading of 10 records at a time, datafetch 10, pager size 10, all columns set for server sorting.

It initially loads directly from

myfile.php

On paging, it then loads from

myfile.php?continue=true&count=10&start=10

Continue paging, another 10, and so on. So far so good.

But once I start sorting, problems come in. Say on page 2 I sort on one of the columns, it goes to:

myfile.php?continue=true&count=10&start=19&sort[field1]=asc

If I then page forward, it goes to

myfile.php?continue=true&count=10&start=24&sort[field1]=asc

Then 32, then 41, then 46, then 51, then 53, then 60

Doesn’t seem to make sense. In some of those cases there are multiple loads (calls to the server) happening PER page. That slows it down significantly. And also, on some of the pages there are empty rows in the datatable.

What would cause this?

2

Any input on this?

I stripped down to basics, downloaded version 3.3, and built a new datatable. Still seeing the behavior. What’s more, I have found that when it hits the server multiple times per page, it ends up actually skipping records and jumping ahead to data from the next server call.

This is making paging unusable which is a problem!

Thanks

3

Well, after going at this repeatedly, I tried rolling my own PHP script to do dynamic loading, and it works. No problems when paging and server-sorting against a load of x records at a time. This tells me there must be a bug in the PHP Data Connector.

FYI for those who run into the same issue or until we have the Webix folks weigh in on this.

BTW I tried downloading and using the latest version of the Connector posted on the DHTMLX site as well - same problem occurred.

4

Some update one year later:
Paging with dynamic loading from a backend still works perfectly.
But as soon as I click on the header of my (partially loaded) datatable I get an "Uncaught TypeError: Cannot read property ‘id’ of undefined’. Seems like the webix sorting algo tries to get IDs of yet empty rows.