Index column (static number column) + Server-Side-Processing = Missing Column Index numbers...
Index column (static number column) + Server-Side-Processing = Missing Column Index numbers...
douglas
Posts: 5Questions: 0Answers: 0
Hi everyone,
I didn't know under which category I should put this, so I picked "DataTables 1.9".
I am using server-side-processing to get all the data on screen. But once I change the number of shown entrys ( 'bLengthChange': true ) or use the navigation ( 'bPaginate': true ), the index column numbers aren't there anymore.
They are there every time I reload the whole page.
Same sever-side-script is in use in all cases.
Is this some kind of a bug? Or do I need to add anything in my code below?
[code]
oTable = $('.datatable').dataTable({
"bServerSide": true,
"sServerMethod": "POST",
"sAjaxSource": "ajax/datatables.content.php",
'bLengthChange': true,
'bPaginate': true,
"iDisplayLength": 25,
"aLengthMenu": [[25, 50, 75, -1], [25, 50, 75, "All"]],
'sPaginationType': 'full_numbers',
'bInfo': false,
'oLanguage':
{
"sProcessing": "Bitte warten...",
"sLengthMenu": "_MENU_ Einträge anzeigen",
"sZeroRecords": "Keine Einträge vorhanden.",
"sInfo": "_START_ bis _END_ von _TOTAL_ Einträgen",
"sInfoEmpty": "0 bis 0 von 0 Einträgen",
"sInfoFiltered": "(gefiltert von _MAX_ Einträgen)",
"sInfoPostFix": "",
"sSearch": "Suchen:",
'oPaginate':
{
'sNext': '>',
'sLast': '>>',
'sFirst': '<<',
'sPrevious': '<'
}
},
"sDom": 'T<"H"lfr>t<"F"ip>',
"oTableTools": {
"aButtons": [
"copy", "csv", "xls", "pdf",
{
"sExtends": "collection",
"sButtonText": "Save",
"aButtons": [ "csv", "xls", "pdf" ]
}
]
},
'aoColumns': [
{ "bSortable": true, "aTargets": [ 0 ] },
null,
null,
null,
null,
null,
null,
null,
null,
{ "sType": "html" },
{ "bSearchable": false, "bVisible": false }
],
"fnDrawCallback": function ( oSettings ) {
/* Need to redo the counters if filtered or sorted */
if ( oSettings.bSorted || oSettings.bFiltered )
{
for ( var i=0, iLen=oSettings.aiDisplay.length ; i
I didn't know under which category I should put this, so I picked "DataTables 1.9".
I am using server-side-processing to get all the data on screen. But once I change the number of shown entrys ( 'bLengthChange': true ) or use the navigation ( 'bPaginate': true ), the index column numbers aren't there anymore.
They are there every time I reload the whole page.
Same sever-side-script is in use in all cases.
Is this some kind of a bug? Or do I need to add anything in my code below?
[code]
oTable = $('.datatable').dataTable({
"bServerSide": true,
"sServerMethod": "POST",
"sAjaxSource": "ajax/datatables.content.php",
'bLengthChange': true,
'bPaginate': true,
"iDisplayLength": 25,
"aLengthMenu": [[25, 50, 75, -1], [25, 50, 75, "All"]],
'sPaginationType': 'full_numbers',
'bInfo': false,
'oLanguage':
{
"sProcessing": "Bitte warten...",
"sLengthMenu": "_MENU_ Einträge anzeigen",
"sZeroRecords": "Keine Einträge vorhanden.",
"sInfo": "_START_ bis _END_ von _TOTAL_ Einträgen",
"sInfoEmpty": "0 bis 0 von 0 Einträgen",
"sInfoFiltered": "(gefiltert von _MAX_ Einträgen)",
"sInfoPostFix": "",
"sSearch": "Suchen:",
'oPaginate':
{
'sNext': '>',
'sLast': '>>',
'sFirst': '<<',
'sPrevious': '<'
}
},
"sDom": 'T<"H"lfr>t<"F"ip>',
"oTableTools": {
"aButtons": [
"copy", "csv", "xls", "pdf",
{
"sExtends": "collection",
"sButtonText": "Save",
"aButtons": [ "csv", "xls", "pdf" ]
}
]
},
'aoColumns': [
{ "bSortable": true, "aTargets": [ 0 ] },
null,
null,
null,
null,
null,
null,
null,
null,
{ "sType": "html" },
{ "bSearchable": false, "bVisible": false }
],
"fnDrawCallback": function ( oSettings ) {
/* Need to redo the counters if filtered or sorted */
if ( oSettings.bSorted || oSettings.bFiltered )
{
for ( var i=0, iLen=oSettings.aiDisplay.length ; i
This discussion has been closed.