Server sided paging

Webix JS
1

Hello,

I am currently writing an application where i use a datatable to show a list of very very much rows.
Because of that I wanted to use server sided paging - so the pages should be loaded from the server.
And so even the sorting and filtering has to be done of the server.
Is there any possibility to do this using the webix datatable?
Is it possible using the paging of the table or do I have to write it on my own?

Thanks!

Regards
Gerhard

2

Hello,

Webix datatable supports dynamic loading combined with paging.

In addition to the pager, you should specify a datafetch parameter for the datatable that sets the number of records that will be loaded from server with every next query. The queries are automatically sent to server during paging.

view:"datatable",
...
datafetch:60, 
pager:{
	container:"paging_here",
	size:30, 
	group:5
},
url:"data/data_dyn.php"

http://docs.webix.com/samples/15_datatable/19_paging/03_db_data_dyn.html

Serverside sorting and filtering are possible as well:

//text server filter
 { id:"title",header:["Film title", {content:"serverFilter"}]},
//sorting
 {id:"year", header:"Year", sort:"server"}

In addition, the next version of Webix will show up a server select filter.

3

I am using a pager combined with datatable server side, I have followed your suggestions and everythings is working fine. There is only a strange behaviour:
I have used the following template: “{common.first()} {common.prev()} {common.pages()} {common.next()} {common.last()}” and when I click on last button the grid, correctly, shows me the last items.
When I start to navigate with arrows keys on my keyborad from the last item, when I reach the item on top of the grid, the data jumps , unexpectedly, on the first page instead on the last-1 page.

I use:

onSelectChange: function () {
this.setCursor(this.getSelectedId());
},

on datatable and it seems that only items buffered in the cursor can be navigate.
What’s I’m doing wrong?

6

I apologize, maybe because datatable loose focus. If I keep focus on datatable , scrolling is fine