Problem with serverside processing, sorting, filtering and refresh of the table
Problem with serverside processing, sorting, filtering and refresh of the table
Hello,
I am using the latest version of the code, here is my code:
[code]
$('#listeProps').dataTable({
"bJQueryUI" : true,
"sPaginationType" : "full_numbers",
"iDisplayLength": 10,
"sScrollY": "400",
"bScrollCollapse": true,
"bProcessing" : true,
"bServerSide" : true,
"sAjaxSource" : basePath +"/listePdC",
"oLanguage": {
"sProcessing": "Traitement en cours...",
"sSearch": "Rechercher :",
"sLengthMenu": "Afficher _MENU_ éléments",
"sInfo": "Affichage de l'élement _START_ à _END_ sur _TOTAL_ éléments",
"sInfoEmpty": "Affichage de l'élement 0 à 0 sur 0 éléments",
"sInfoFiltered": "(filtré de _MAX_ éléments au total)",
"sInfoPostFix": "",
"sLoadingRecords": "Chargement en cours...",
"sZeroRecords": "Aucun élément à afficher",
"sEmptyTable": "Aucune donnée disponible dans le tableau",
"oPaginate": {
"sFirst": "Premier",
"sPrevious": "Précédent",
"sNext": "Suivant",
"sLast": "Dernier"
},
"oAria": {
"sSortAscending": ": activer pour trier la colonne par ordre croissant",
"sSortDescending": ": activer pour trier la colonne par ordre décroissant"
}
},
"fnServerData": function( sUrl, aoData, fnCallback ) {
this.jqXHR = $.ajax( {
"url": sUrl,
"data": aoData,
"success": function(json) {
fnCallback(json);
//toto.fnDraw();
},
"dataType": "json",
"cache": false
} );
}
}).columnFilter({
sPlaceHolder: "head:after",
aoColumns: [ { type: "text"},
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" }
]
});
[/code]
My pb is that when I click on a column header, on a filter or on the pagination, the server is correctly called but nothing happens on the table, only the processing message at the top...
Any idea?
I am using the latest version of the code, here is my code:
[code]
$('#listeProps').dataTable({
"bJQueryUI" : true,
"sPaginationType" : "full_numbers",
"iDisplayLength": 10,
"sScrollY": "400",
"bScrollCollapse": true,
"bProcessing" : true,
"bServerSide" : true,
"sAjaxSource" : basePath +"/listePdC",
"oLanguage": {
"sProcessing": "Traitement en cours...",
"sSearch": "Rechercher :",
"sLengthMenu": "Afficher _MENU_ éléments",
"sInfo": "Affichage de l'élement _START_ à _END_ sur _TOTAL_ éléments",
"sInfoEmpty": "Affichage de l'élement 0 à 0 sur 0 éléments",
"sInfoFiltered": "(filtré de _MAX_ éléments au total)",
"sInfoPostFix": "",
"sLoadingRecords": "Chargement en cours...",
"sZeroRecords": "Aucun élément à afficher",
"sEmptyTable": "Aucune donnée disponible dans le tableau",
"oPaginate": {
"sFirst": "Premier",
"sPrevious": "Précédent",
"sNext": "Suivant",
"sLast": "Dernier"
},
"oAria": {
"sSortAscending": ": activer pour trier la colonne par ordre croissant",
"sSortDescending": ": activer pour trier la colonne par ordre décroissant"
}
},
"fnServerData": function( sUrl, aoData, fnCallback ) {
this.jqXHR = $.ajax( {
"url": sUrl,
"data": aoData,
"success": function(json) {
fnCallback(json);
//toto.fnDraw();
},
"dataType": "json",
"cache": false
} );
}
}).columnFilter({
sPlaceHolder: "head:after",
aoColumns: [ { type: "text"},
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" },
{ type: "text" }
]
});
[/code]
My pb is that when I click on a column header, on a filter or on the pagination, the server is correctly called but nothing happens on the table, only the processing message at the top...
Any idea?
This discussion has been closed.
Replies