Answers

• kthorngren Posts: 21,343Questions: 26Answers: 4,954

  March 2018

  You need to change table.column( [0 ,1 ] ) to table.columns( [0 ,1 ] ).. Notice the plural columns,

  Kevin
• welle77 Posts: 8Questions: 3Answers: 0

  March 2018

  Thank you for your help. With this change it seams to me that it show rows where all columns (0,1) maches the search string (AND). But it should be OR to fullfill my requirements.
• kthorngren Posts: 21,343Questions: 26Answers: 4,954

  March 2018

  Yes, the search is an AND between the columns. You would need to create a custom search. I suggest looking at creating a search plugin:
  https://datatables.net/manual/plug-ins/search

  Kevin
• welle77 Posts: 8Questions: 3Answers: 0

  March 2018

  Thanks, Kevin. I solved it this way:

  $('#myInputTextField').keyup(function(){
      var searchTerm = this.value.toLowerCase();
      $.fn.dataTable.ext.search.push(function(settings, data, dataIndex) {
         //search only in the following columns (0 and 1) with OR operator
         if (~data[0].toLowerCase().indexOf(searchTerm)) return true;
         if (~data[1].toLowerCase().indexOf(searchTerm)) return true;
         return false;
     })
     table.draw(); 
     $.fn.dataTable.ext.search.pop();
  })