Modify DataTables Button Action

Question

I want to add the search keyword to the URL of a custom button action element in order to pass the keyword as a GET parameter.

I am initializing the data table like so:

var table = $('#list').DataTable( {
        dom: 'lBfrtip',
    buttons: [
        {
             text: 'Export to PDF',
             className: 'export-to-pdf',
             action: function ( e, dt, button, config ) {
                 window.open('generate_pdf.php?case_id=<?= $case_id? ?>','_blank');
      }

And attempting to append the keyword to the URL using:

// append keyword search values to pdf url
$('#list').on('search.dt', function() {
    var keyword = $('.dataTables_filter input').val();
    //FAILS HERE
    var export_pdf_url = $(".export-to-pdf").attr("href");
    // remove keywords if they already exist
    removeURLParameter(export_pdf_url, 'keyword');
    // append filter value to filtered pdf href
    $(".export-to-pdf").attr("href", export_pdf_url + '&keyword='+keyword);
});

This seems to be failing because the action function is not actually assigning the the button a href attribute.

Any suggestions on how to dynamically modify the action function or other approaches would be very much appreciated.

Are you using client-side or server-side processing mode?

Gyrocode.com
– Gyrocode.com

2019-03-28 02:01:05 +00:00
Commented Mar 28, 2019 at 2:01 — Gyrocode.com
– Gyrocode.com, Commented Mar 28, 2019 at 2:01
client side processing

user1392897
– user1392897

2019-03-28 02:10:00 +00:00
Commented Mar 28, 2019 at 2:10 — user1392897
– user1392897, Commented Mar 28, 2019 at 2:10

Gyrocode.com · Accepted Answer · 2019-03-28 02:17:30Z

1

Use search() API method which returns currently applied global search when called without arguments.

Then generate URL directly in the callback function for action option.

For example:

buttons: [
   {
      text: 'Export to PDF',
      className: 'export-to-pdf',
      action: function ( e, dt, button, config ) {
         var query = dt.search();
         window.open('generate_pdf.php?case_id=<?= $case_id? ?>&keyword=' + encodeURIComponent(query), '_blank');
      }
   }
],

edited Mar 28, 2019 at 2:17

answered Mar 28, 2019 at 2:05

Gyrocode.com

59k16 gold badges157 silver badges192 bronze badges

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

1 Comment

user1392897 Over a year ago

wow that is exactly what I was looking for. super clean solution. thanks a ton.

Collectives™ on Stack Overflow

Modify DataTables Button Action

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related