Server Side Data and Client Side Sorting
Server Side Data and Client Side Sorting
I've been working with your DataTables plugin, and I must first say this is the best jQuery table plugin that I've seen. I do however, have a small problem. I am trying to retrieve data using sAjaxSource, but have all sorting, paging, and filtering on the client side. My code block is below for my DataTables object. It seems that making the bProcessing value to false does not change the behavior of the sorting. Loading in Firefox, I can see DataTables doing an AJAX call everytime I try to sort. Any help would be greatly appreciated.
[code]
$(document).ready(function() {
/* Init DataTables */
oTable = $('#example').dataTable({
"bJQueryUI": true,
"bStateSave": false,
"bProcessing": false,
"bServerSide": true,
"bPaginate": false,
"bFilter": false,
"bAutoWidth": true,
"bLengthChange": true,
"sAjaxSource": "media/serverside/FileList.aspx",
"aoColumns": [
{"bSearchable": false, "sWidth": "15px", "bSortable": false }, // icon
{"bSearchable": false, "sWidth": "15px", "bSortable": false}, // attachments
{"bSearchable": false }, //Subject Line
{"bSearchable": false }, // Date Sent
{"bSearchable": false, "bVisible": false} // File Name
],
"aaSorting": [[1, 'asc']],
//"fnDrawCallback": fnOpenClose,
"fnServerData": fnPostServerData,
"fnRowCallback": fnRenderRow
});
[/code]
[code]
$(document).ready(function() {
/* Init DataTables */
oTable = $('#example').dataTable({
"bJQueryUI": true,
"bStateSave": false,
"bProcessing": false,
"bServerSide": true,
"bPaginate": false,
"bFilter": false,
"bAutoWidth": true,
"bLengthChange": true,
"sAjaxSource": "media/serverside/FileList.aspx",
"aoColumns": [
{"bSearchable": false, "sWidth": "15px", "bSortable": false }, // icon
{"bSearchable": false, "sWidth": "15px", "bSortable": false}, // attachments
{"bSearchable": false }, //Subject Line
{"bSearchable": false }, // Date Sent
{"bSearchable": false, "bVisible": false} // File Name
],
"aaSorting": [[1, 'asc']],
//"fnDrawCallback": fnOpenClose,
"fnServerData": fnPostServerData,
"fnRowCallback": fnRenderRow
});
[/code]
This discussion has been closed.
Replies