Answers

• rf1234 Posts: 3,000Questions: 87Answers: 421

  November 2018 edited November 2018 Answer ✓

  Here is an example.

  These are my buttons. You need to give the remove button a name to refer to.

  var rateTable = $('#tblRate').DataTable( {
  ...............
  columns: [
          {   data: "rate.ref_rate" },
          {   data: "rate.currency" },
          {   data: "rate.ref_rate_period" },
          {   data: "rate.date" },
          {   data: "rate.rate" },
          {   data: "rate.update_time" }
      ],
  .............
  select: {
          style: 'multi'
      },            
      buttons: [
          {   extend: "create", editor: rateEditor },
          {   extend: "edit",   editor: rateEditor },
          {   extend: "remove", editor: rateEditor, name: "remove" },
                      "colvis"
      ]
  } );
  

  And here are the select and deselect event handlers.

  rateTable
      .on('select', function () {
          rateTable.rows({selected: true}).every( function ( rowIdx, tableLoop, rowLoop ) {
              var data = this.data();
              if ( data.rate.ref_rate_period == '1month') {
                  rateTable.button( 'remove:name' ).disable();
              }
          });
      })
      .on('deselect', function () {
          rateTable.rows({selected: true}).every( function ( rowIdx, tableLoop, rowLoop ) {
              var data = this.data();
              if ( data.rate.ref_rate_period == '1month') {
                  rateTable.button( 'remove:name' ).disable();
              }
          });
      });
  

  Just adjust it to your situation e.g data.yourTable.active == 1 or something.

  Why "deselect":
  If you allow multi select and someone selects multiple records of which some must not be deletable you must also check the condition on deselect otherwise the user will be able also to delete forbidden records on the first deselect.
• dg_datatables Posts: 53Questions: 10Answers: 1

  November 2018

  Works!
  Thanks a lot