Data loaded using server side script but filtering/sorting/etc done on client side
Data loaded using server side script but filtering/sorting/etc done on client side
![dzida](https://secure.gravatar.com/avatar/4d1990d0daef811f7dc6633795c86dc1/?default=https%3A%2F%2Fvanillicon.com%2F4d1990d0daef811f7dc6633795c86dc1_200.png&rating=g&size=120)
Hi all,
I have datatable created using this script:
[code]
$("table#offices-table").dataTable({
"oLanguage": {
"sUrl": "/site_media/language/pl_PL.txt"
},
"bProcessing": true,
"bInfo": false,
"bAutoWidth": false,
"bPaginate": false,
"sServerSide":true,
"bJQueryUI": true,
"sAjaxSource": "some-url",
"aoColumns": [
null,
null,
null,
{ "bSortable": false },
{ "bSortable": false }
]
});
[/code]
This table is filled by proper data received from server, but when I use sort/filter feature there is no call to the server - sorting and filtering are done on client side.
I have also noticed that when 'some-url' is called for the first time it is done without parameters required by datatables.
I have datatable created using this script:
[code]
$("table#offices-table").dataTable({
"oLanguage": {
"sUrl": "/site_media/language/pl_PL.txt"
},
"bProcessing": true,
"bInfo": false,
"bAutoWidth": false,
"bPaginate": false,
"sServerSide":true,
"bJQueryUI": true,
"sAjaxSource": "some-url",
"aoColumns": [
null,
null,
null,
{ "bSortable": false },
{ "bSortable": false }
]
});
[/code]
This table is filled by proper data received from server, but when I use sort/filter feature there is no call to the server - sorting and filtering are done on client side.
I have also noticed that when 'some-url' is called for the first time it is done without parameters required by datatables.
This discussion has been closed.
Replies
Try putting
[code]"bServerSide":true,[/code]
instead of
[code]"sServerSide":true,[/code]
BB
this works great now!