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
75.1K
All Categories
57
Priority support
24.6K
Free community support
1K
General
14
Announcements
2.6K
DataTables
127
DataTables 2
1.3K
DataTables 1.10
93
DataTables 1.9
35
DataTables 1.8
9
CloudTables
2.2K
Editor
2.8K
Extensions
20
AutoFill
314
Buttons
34
ColReorder
4
ColumnControl
33
DateTime
68
FixedColumns
51
FixedHeader
31
KeyTable
106
Responsive
24
RowReorder
43
Scroller
168
SearchBuilder
200
SearchPanes
107
Select
27
StateRestore
220
Bug reports
68
Feature requests
101
Plug-ins
11
Blog
73
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]