[eluser]Tonko[/eluser]
Hi all, I need your help. I have table where is 404 rows and I use ignited datatables library to show them.
I have problem, because the ignited datatables library always return MAX 100rows
But my controller show this: {"sEcho":0,"iTotalRecords":402,"iTotalDisplayRecords":402,"aaData" [and here is only 100 records, not all 404]...
this is my jquery code in view:
Code:
var oTable = $('.mws-datatable-fn').dataTable( {
"bProcessing": true,
"aLengthMenu": [[10, 25, 50, 100, 500, 1000, 5000, -1], [10, 25, 50, 100, 500, 1000, 5000, "All"]],
"iDisplayLength": 1000,
"sAjaxSource": "<?php echo base_url(); ?>companies/datatables",
"sPaginationType": "full_numbers"
} );
and my controller:
Code:
$this->load->library('companies/datatables');
$this->datatables->select('id, name, kind, address_city, address_country, sales_agent');
$this->datatables->from('companies');
echo $this->datatables->generate();
... is this bug or how to solve it? Thanks for help