Pass DataTable reference to the callback function on load

Question

My current code is:

var CommissionLogs = $("#CommissionLogs").DataTable({       
     ajax: {
         url: ajaxurl + '?action=pos&post_action=get_commissions'
      },
    'initComplete': function (settings, json){
        //possible to access 'this'
        this.api().columns(1);
    }
  });

I improved the code above as below with help :

var CommissionLogs = $("#CommissionLogs").DataTable({       
     ajax: {
         url: ajaxurl + '?action=pos&post_action=get_commissions'
      },
    'initComplete': function(settings, json){ 
        callbackFunction(settings);
     }
  });

 function callbackFunction(settings){
     var api = new $.fn.dataTable.Api( settings );
     // api is accessible here.
 }

Update :

Now I can access api from callback function. But I want use same callback with load() as below code.

CommissionLogs.ajax.url( newAjaxURL ).load( callbackFunction(), true);

But settings param is not accessible in load function.

I can clear and destroy datatable and re initialize always. But what will be the right way.

Dani · Accepted Answer · 2022-03-02 10:38:19Z

1

I think you need settings:

https://datatables.net/reference/type/DataTables.Settings

$('#example').dataTable( {
    "initComplete": function(settings, json) {
        myFunction(settings);
    }
});

function myFunction(settings){
    var api = new $.fn.dataTable.Api( settings );
 
    // Output the data for the visible rows to the browser's console
    // You might do something more useful with it!
    console.log( api.rows( {page:'current'} ).data() );
}

Other option is re-use your var CommissionLogs variable throughout the code without using this, I recommend strongly this last option.

edited Mar 2, 2022 at 10:38

answered Mar 2, 2022 at 10:32

Dani

2,0862 gold badges20 silver badges32 bronze badges

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

2 Comments

Md Masud Over a year ago

Yeah, That is helpful. But ajaxTable.ajax.url( newurl ).load( mycallback(settings), true); not work. can not access settings.

Dani Over a year ago

@infomasud Ok, use second option and re-use var CommissionLogs for access whatever you want

Md Masud · Accepted Answer · 2022-03-02 11:15:40Z

0

The dataTable.ajax.url().load() has not access to settings.

So can not call a callback function with settings.

But possible to use callback function without settings.

So here is an alternative way to use settings.

 CommissionLogs.clear();// clear the table
 CommissionLogs.destroy();// destroy the table
 CommissionLogs = $("#CommissionLogs").DataTable({           
         ajax: {
            url: newAjaxUrl
         },
        'initComplete': function (settings, json){
            callbackDatatableFunciton(settings);
        }
    });

answered Mar 2, 2022 at 11:15

Md Masud

2,7511 gold badge24 silver badges16 bronze badges

Collectives™ on Stack Overflow

Pass DataTable reference to the callback function on load

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related