Answers

• kthorngren Posts: 22,329Questions: 26Answers: 5,135

  June 2017

  One way of attempting to remove rows is to use filter() and rows().remove(). Try the below example and update as needed:

                                var filteredData = table
                                    .rows()
                                    .indexes()
                                    .filter( function ( value, index ) {
                                       return table.row(value).data()[0] == 3;  
                                    } );
                                table.rows( filteredData )
                                .remove()
                                .draw();
  

  This gets the row indexes where column 0 == 3 and stores them in filteredData. filteredData is then used as the row selector and those rows are removed and the table redrawn. You may need to change the column number in line 5 to the name of the column depending on your config.

  Kevin
• allan Posts: 65,347Questions: 1Answers: 10,841 Site admin

  June 2017

  Good thinking Kevin!

  Another option is to use the row-selector option as a function:

  table
      .rows( function ( idx, data, node ) {
          return data[0] === 3;
      } )
      .remove()
      .draw();
  

  Its basically the same thing, just using a little shortcut.

  Allan
• hanmumu Posts: 5Questions: 2Answers: 0

  March 2019

  Hey guys! Just wanna point out something that had me deleting the opposite rows that I needed:

  In @kthorngren 's answer it's supposed to be

  .filter( function ( index, value) {
  

  I mean, it's more descriptive that way. I was using the "index" to get at my rows and what I was actually using was the value.
  Still, this is what solved my day-long problem! Thank you so much