Server side response in jQuery datatables

Question

I'm using server-side processing in jQuery DataTables, but the rows aren't getting added to the table. They are present in the AJAX success, and the rows are also in the data parameter, but they aren't getting added to the table.

otable = $('#siteselectiontable').DataTable({
    "serverSide": true,
    "deferLoading": 0,
    "processing": true,
    "paging": true,
    "columns": [{
        "data":"RADIO"
    },
    {
    "data":"SITE_DATA"  
    }
    ],
    "ajax": {
        success: function(data) {
            if(typeof data['error']!="undefined"){
                bootbox.alert({
                    closeButton: false,
                    message: "<div class='alert alert-danger' role='alert'>" +
                        "<strong>Timeout Error: </strong>Please refine your search" +
                        "</div>"
                });
            }
        },
        beforeSend: function() {
            $("#siteselectionfooter").after(progress);
        },
        complete: function() {
            $(".loading-mask").remove();
        }
    },
    "searching": false,
    "ordering": false,
    "lengthChange": false,
    "pageLength": 5,
    "dom": '<"top"><"pull-right"f>t<"bottom center"p><"clear">',
    "fnRowCallback": function(nRow, aData, iDisplayIndex, iDisplayIndexFull) {
        $('td:eq(0)', nRow).css({
            'text-align': 'center',
            'vertical-align': 'middle'
        });
    }
});

and for the ajax call i am using the below:

table.ajax.url(url).load();

how can i handle the server side error in a custom way ?

i have define the headers ,rows were also coming ,but sometimes error is also coming which i want to show it my way ,for that i define the "success" but after adding it rows weren't added to table. — Harish Gupta
– Harish Gupta, Commented Aug 4, 2017 at 4:58

Harish Gupta · Accepted Answer · 2017-08-04 05:51:09Z

2

i have resolved this with dataSrc in ajax options and adding the below line

$.fn.dataTable.ext.errMode = 'none';    



"ajax": {
        beforeSend: function() {
            $("#siteselectionfooter").after(progress);
        },
        complete: function() {
            $(".loading-mask").remove();
        },
        "dataSrc": function ( json ) {
            if(typeof json['error']!="undefined"){
                bootbox.alert({
                    closeButton: false,
                    message: "<div class='alert alert-danger' role='alert'>" +
                        "<strong>Timeout Error: </strong>Please refine your search" +
                        "</div>"
                });
            }
            return json.data;
         }
    },

answered Aug 4, 2017 at 5:51

Harish Gupta

4022 gold badges9 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Server side response in jQuery datatables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related