Load Two Datatables simultaneously

Webix JS
#1

Hi,

I have defined tow datatables

activeTableColumns['definition'].push({
	'container' : 'tbl_table_active', 
	'pagination' : 'active_paging_here',
	'url'  : '&active=1'
});

archiveTableColumns['definition'].push({
	'container' : 'tbl_table_archive', 
	'pagination' : 'archive_paging_here',
	'url'  : '&archive=1'
});

Then I have the columns definition

activeTableColumns["columns"].push({
    id: "chk",
    template: '<input type="checkbox" value="#id#">',
    footer:{text:"", colspan:3},
    header: "",
    width: 50
}, ......

archiveTableColumns["columns"].push({
    id: "chk",
    template: '<input type="checkbox" value="#id#">',
    footer:{text:"", colspan:3},
    header: "",
    width: 50
}, ......

and finally for the definition

var columnDefinitions = [];
columnDefinitions.push(activeTableColumns);
columnDefinitions.push(archiveTableColumns);

For Initialization of Datatables I implement

tableColumnsDefinitions = initColumns(); // It has the column          
definition(activeTableColumns, archiveTableColumns)

webix.ready(function(){

		$.each(tableColumnsDefinitions, function(index, item){

   grid[item.definition[0].container] =
			webix.ui({

				container: item.definition[0].container,
				view:"datatable",
		 
                minColumnWidth:100,      
			 	footer:true,
				columns: item.columns,
				navigation:true,
				autoheight:true,
				resizeColumn:true,
				resizeRow:true,
				dragColumn:true,
				datafetch:200,  
				loadahead:200, 

                url:   url + "remote=service&data=1" + item.definition[0].url
#2

In my Inspect Element → Network Tab I get three requests like in the image

How can I avoid it and get only 2 requests for the 2 Datatables ?

I use serverSide Pagination

#3

Its problem that the url produce records from 0 to 200 for the active datatable first request and then makes a second request for active datatable with start = 199 and count = 200 and return a new json and the records from 0 to 200 are replaced from the new returned.

In this example http://docs.webix.com/samples/15_datatable/16_dyn_loading/04_db_dyn_loadahead.html

The json data is already set and not created by PHP dynamically.

#4

Here is also the two requests that sends
http://docs.webix.com/samples/15_datatable/16_dyn_loading/04_db_dyn_loadahead.html

629×873 65.7 KB

#5

Please, don’t use the loadahead setting to avoid this behaviour. The thing is that the first request loads the stated portion of data (datafetch) and then the Datatable requests for the rest of data (loadahead).