Pages, Filters, Order dont working server-side

[fehsc]

Order, Filters, dont working with serve-side. How do?

[hmrc87]

Same probleme here, using CI3 and Ignited-Datatables 2.0 it doesnt seem to work

[iMezied]

the same issue here with CI 2.2.1

[hmrc87]

Try adding the post attribute to your JavaScript code in the view like this

"ajax": {
"url":'job/dt_get_all_jobs',
"type": "POST"
},
Columns{

That worked for me

[iMezied]

awesome!
its work with me too
thanks @Hmarc187

[gabrielpaivadev]

Me does not work

$("#tabela_ecommerce").dataTable({
"processing": true,
"serverSide": true,
"deferRender": false,
"iDisplayLength": 4,
"iDisplayStart": 0,
"sServerMethod": "POST",
"sAjaxSource": "projeto/ajaxCarregarProdutos",
"fnServerData": function (sSource, aoData, fnCallback) {
$.ajax
({
"dataType": "json",
"type": "POST",
"url": sSource,
"data": aoData,
"success": fnCallback
});
},
"aoColumns": [
{"mData": "imagem_produto", "sClass": "text-center"},
{"mData": "codigo_produto", "sClass": "text-center", "bSearchable": true},
{"mData": "nome_produto", "bSearchable": true},
{"mData": "quantidade_produto", "sClass": "text-center"},
{"mData": "valor_produto"},
{"mData": "selecionar_produto", "sClass": "text-center"}
]
});

[baktistr]

for me, I added post attribute in my js. it just search/filter that doesnt work, everything else works fine.. it always give me error 500.. any idea?

[christianrd]

@baktistr I get this error to (error 500), I think this error is about sql script for where -> like it's doesn't specify the attribute in database... I don't know how I can fix it in datatable library CI