My Datatables freezes when no results from ajax url

kabeza

I've a table which also has an external select used to filter the table with an ajax parameter

$("#seldepartamento").change(function(event) {
    myTable.draw();
});

var myTable = $('#myTable').DataTable({
    "processing": true,
    "serverSide": true,
    "serverMethod": "post",
    "ajax": {
        "url": '/datos_json',
        data: function(data) {
            data.param1 = $('#seldepartamento').val();
        }
    },
    "bFilter": true,
    "ordering": true,
    "order": [[ 1, "asc" ]],
    "deferRender": true,
    "responsive": true,
    "lengthMenu": [ [10, 50, 100, -1], [10, 50, 100, "Todos"] ],
    "pageLength": 50,
    "sPaginationType": "full_numbers",
    "bPaginate": true
});

All works fine except the table shows "Processing" in case my selection (external filter) or search matches 0 records... I have to change option or empty the table's search field for it to work fine again. The table should show "No data available in this table" or something similar... The json returned (when there are no matches in db) is

{"draw":1,"recordsTotal":0,"recordsFiltered":0,"data":"[]"}

Thanks

kthorngren

I believe your JSON should look like this:
{"draw":1,"recordsTotal":0,"recordsFiltered":0,"data":[]}

Notice no quotes around the [] in the data object.

Kevin

kabeza

Hi Kevin
That was the trick!

Thanks!