Answers

• kthorngren Posts: 20,300Questions: 26Answers: 4,769

  February 2020 Answer ✓

  I want to filter the Datatable based on the first 1-4 invisible columns. (col1=?) AND (col2=?)... So could be just 1st col, could be all 4.

  The column().search() API is used to search the table on a column by column basis. You could use columns().search() to search multiple columns for the same search term. Column numbers start counting from 0. The first column is 0.

  I would like to apply each filter request on button click event.
  Could someone point me in right direction?

  Here is a simple example searching a hidden column via a button:
  http://live.datatables.net/wuhelusa/1/edit

  Also how to remove a filter?

  See the same example. Use an empty string, ie "", to clear the search.

  Kevin
• alp Posts: 4Questions: 2Answers: 0

  February 2020

  Thank you! For Multi this work very nice:

  table.column(0).search('tiger');
  table.column(1).search('sys');
  table.column(2).search('');
  table.column(3).search('').draw();