Search

i added the following code and it seems to help: $('#users').dataTable( { "processing": true, "serverSide": true, "order":[[1,"asc"]], "ajax": "/cgi-bin/widgets", "columns": [ { "data": "id" }, { "data": "available" }, { "data": "name" }, { "data": "code" } ] } );

Hi, It looks like you need to add a success function to your $.ajax call. Something like: success: function () { window.close(); } If you are closing the window, why would you update the DataTable, since it is about to disappear? Allan

Thanks for the link Custom plugin might be a little bit beyond my expertise at the mo. but I will take a look

If you search the forum, you'll find a number of posts discussing multi-layered data in DataTables. This is not something that DataTables supports. Allan

@Allen.... Can you please give me some workaround.

Hi g1618344, please via this link https://datatables.net/reference/api/row%28%29.data%28%29 and https://datatables.net/forums/discussion/27167/how-do-get-data-in-row-datatable#latest thank you

Thanks Allan - as soon as I have an update on this I can update this thread too!

Issue got fixed, Earlier i was passsing 1 by default to sEcho variable from server side. I changed that to sEcho = param.sEcho. Now it works fine.

Maybe this is not possible? It does appear to work, but if you try to delete a row after adding, the added rows go back to the bottom. Here is the pertinent code code from the above live site: testTable = $('#test-table').DataTable({ "data": dataForDataTables, "destroy": true, "pageLength": 25, "columns": [ { "data": "SortIndex" }, { "data": "DataGroup", "orderable": false }, { "data": "Number1", "orderable": false }, { "data": "Number2", "orderable": false }, { "data": "Label1", "orderable": false }, { "data": "Label2", "orderable": false }, { "data": "Delete", "orderable": false, "render": delete_icon }, { "data": "Insert", "orderable": false, "render": add_icon } ] }); $('#test-table tbody').on('click', 'i.glyphicon-plus-sign', function (event) { var insertedRowIndex = testTable.row($(this).parents('tr')).index(); addRow(); var lastRowIndex = testTable.page.info().recordsTotal - 1; //re-number sortIndex column to reflect added row $.each(testTable.rows().data(), function (i, row) { var firstCell = testTable.cell(i, 0); if (i < insertedRowIndex) { firstCell.data(i); } else if (i >= insertedRowIndex && i != lastRowIndex) { firstCell.data(firstCell.data() + 1); } else if (i == lastRowIndex) { firstCell.data(insertedRowIndex); } }) testTable.order([0, 'asc']).draw(); }); function addRow() { testTable.row.add({ "SortIndex": testTable.page.info().recordsTotal, "DataGroup": $("#select-data").val(), "Number1": "", "Number2": "", "Label1": "", "Label2": "" }).draw(); }

could not recognize constants or variables which are declared in external files. They can, but you need to use the use() statement: ->where( function ( $q ) use ( $CONST_STATUS_START, $CONST_GROUP_EMPTY ) { This is all part of PHP's awful handling of globals and variable scope... I quite like PHP, but it does have issues such as this - particularly if you are used to Javascript. Allan