configure datatables but call ajax after filter

Question

My question is simmilar to this: jQuery Datatable - changing data url but I don't want to make the ajax call while setting the datatable

I have this setting for the datatable:

p._createDataTableMappings = function (application, field) {
        $('#data_mappings').DataTable({
            "dom": 'rtip',
            "ajax": {
                "url": "/api/applications/" + application + "/mappings/" + field,
                "dataSrc": ""
            },
            "columns": [
                { "data": "Application1" }, 
                { "data": "Field1" },
                { "data": "Value1" },
                { "data": "Application2" },
                { "data": "Field2" },
                { "data": "Value2" }
            ]
        });

The data returned by the url is an array of objects, so I put the dataSrc to ""

But I don't want to make the ajax call until application and field values have data. These values are set from this function:

$("#search").on("click", function (event) {
    var application_value = $("#application").val();
    var field_value = $("#field").val();
    if (application_value && field_value) {
        var table = $("#data_mappings").DataTable();
        table.ajax.url("/api/applications/" + application_value + "/mappings/" + field_value).load();
    }
});

My doubt is how to configure the ajax call

        "ajax": {
            "url": "/api/applications/" + application + "/mappings/" + field,
            "dataSrc": ""
        },

If I remove the url property I get a warning from datatables saying: Invalid JSON response
If I remove the entire ajax property in the setting function, calling table.ajax.url(myUrl).load() expects an object with a property named data, but I have an array of objects.

I think it's not as easy as changing the url parameter.. The plugin is also doing some caching I guess.. You should rather call table.fnDestroy(); and then you re-init your Datatables with new ajax url. Also check this other SO answer — Yuri
– Yuri, Commented Mar 20, 2018 at 7:38

colin0117 · Accepted Answer · 2018-03-20 10:10:41Z

1

As @Yuri said, the best way is probably to destroy the table and rebuild it. This live example may help - you press a button to load the data, so this would be analogous to your click event.

answered Mar 20, 2018 at 10:10

colin0117

1,5581 gold badge12 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

configure datatables but call ajax after filter

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related