DataTables
Advanced interaction
features for your tables.
Editor
Comprehensive editing
library for DataTables.
Manual
Download
Examples
Manual
Reference
Extensions
Plug-ins
Blog
Forums
Discussions
Sign In
Support
FAQs
Download
Purchase
≡
Show site navigation
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,365
Questions: 39
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.
Sign In
·
Register
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Sign In
Register
Quick Links
Categories
Recent Discussions
Unanswered
Categories
74.4K
All Categories
56
Priority support
24.1K
Free community support
1K
General
14
Announcements
2.5K
DataTables
83
DataTables 2
1.3K
DataTables 1.10
92
DataTables 1.9
35
DataTables 1.8
9
CloudTables
2.2K
Editor
2.8K
Extensions
20
AutoFill
310
Buttons
50
ColVis
30
DateTime
68
FixedColumns
50
FixedHeader
32
ColReorder
30
KeyTable
104
Responsive
23
RowReorder
42
Scroller
166
SearchBuilder
193
SearchPanes
107
Select
26
StateRestore
22
TableTools
220
Bug reports
67
Feature requests
100
Plug-ins
11
Blog
70
Web-site
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]