≡
×
Plus
Manual
Examples
Reference
Download
Blog
Community
Support
Can´t display more than 100 results in client side
Can´t display more than 100 results in client side
kuupa
Posts: 3
Questions: 0
Answers: 0
March 2014
edited March 2014
in
General
I am not being able to display a datatable with more than 100 results working client side, if i use "bServerSide": true the same code works fine and loads all the data.
I have been looking around but can´t find the answer, any clue?
Replies
tangerine
Posts: 3,371
Questions: 42
Answers: 395
March 2014
[quote]please link to a test case showing the problem as required in the forum rules.[/quote]
kuupa
Posts: 3
Questions: 0
Answers: 0
March 2014
It is a simple configuration, without "bServerSide": true, the datatable only gets 100 results.
[code]
var oTable = $('#datatable1').dataTable({
"bProcessing": true,
// "bServerSide": true,
"bStateSave": true,
"bDestroy": true,
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"sAjaxSource": base_url() + '/ccreateexam/getQuestions',
"fnInitComplete": function() {
oTable.fnAdjustColumnSizing();
},
'fnServerData': function(sSource, aoData, fnCallback)
{
$.ajax
({
'dataType': 'json',
'type': 'POST',
'url': sSource,
'data': aoData,
'success': fnCallback
});
}
});
[/code]
kuupa
Posts: 3
Questions: 0
Answers: 0
March 2014
edited March 2014
It was the $iLength at the function get_paging() in Datatables.php, i think it is solved.
This discussion has been closed.
Replies
[code]
var oTable = $('#datatable1').dataTable({
"bProcessing": true,
// "bServerSide": true,
"bStateSave": true,
"bDestroy": true,
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"sAjaxSource": base_url() + '/ccreateexam/getQuestions',
"fnInitComplete": function() {
oTable.fnAdjustColumnSizing();
},
'fnServerData': function(sSource, aoData, fnCallback)
{
$.ajax
({
'dataType': 'json',
'type': 'POST',
'url': sSource,
'data': aoData,
'success': fnCallback
});
}
});
[/code]