datatables ajax reload not updating parameters passed

Question

Using ajax.relaod isn't updating the value that is being passed to the controller. The variables have the correct values each time when entering the function but I'm not sure how to get reload to also see/accept the updated variables. Do I need to destroy and rebuild the table each time?

if (!$.fn.DataTable.isDataTable('.workorder-table')) {
    $('.workorder-table').DataTable({
        "initComplete": function () {
            hidePleaseWait();
        },
        rowCallback: function (row, data, index) {
            --row classes added here based on data
        },
        columns: [
            { "data": "Facility", "name": "Facility", "title": "Facility" },
            { "data": "ShortDescription", "name": "ShortDescription", "title": "Short Description" },
            { "data": "Created", "name": "Created", "title": "Created" },
            { "data": "Completed", "name": "Completed", "title": "Completed" },
            { "data": "Status", "name": "Status", "title": "Status" }
        ],
        ajax: {
            url: "/Facility/WorkOrderSearch",
            type: "POST",
            data: { status: $('#Status').val(), facilityID: $('#FacilityID').val(), quickView: $('#QuickView').val() }
        },
        -- options here
    });
} else {
    $('.workorder-table').DataTable().ajax.reload(hidePleaseWait);
}

data should be a function, i.e data: function(d) { d.status: $('#Status').val() ,... } then it will be executed upon ajax.reload() — davidkonrad
– davidkonrad, Commented Jun 15, 2017 at 11:17
Perfect thank you. If you can turn it into an answer, I can accept it. — Tsukasa
– Tsukasa, Commented Jun 15, 2017 at 11:20

davidkonrad · Accepted Answer · 2017-06-15 11:37:06Z

7

If data is turned into a function that can be executed

data: function(data) {
  data.status = $('#Status').val();
  data.facilityID = $('#FacilityID').val();
  data.quickView = $('#QuickView').val();
}

Then this function will be executed upon each request, i.e when ajax.reload() is called.

answered Jun 15, 2017 at 11:37

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

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

2 Comments

Source Matters Over a year ago

Still applicable 7/27/18 - lifesaver! Is this a "datatables" thing, or a javascript in general thing? (making it a function to execute it each reload)

davidkonrad Over a year ago

@SourceMatters, it is a DataTables enhancement of jQuery AJAX, I believe the code is found here, around line 3871 -> github.com/DataTables/DataTables/blob/master/media/js/… if data is a function the function is executed. jQuery AJAX does not support this (perhaps in a later version, but none I know of)

Collectives™ on Stack Overflow

datatables ajax reload not updating parameters passed

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related