How can I search multiple columns in DataTables?

by

You can override the built in search / filter with a custom filter :

$('.dataTables_filter input').unbind().on('keyup', function() {
    var searchTerm = this.value.toLowerCase();
    $.fn.dataTable.ext.search.push(function(settings, data, dataIndex) {
       //search only in column 1 and 2
       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();
})

By this the “normal search” only applies to the first two columns, Name and Position – and you still have working select boxes in the footer. Forked fiddle -> https://jsfiddle.net/g9gLjtjh/

More Related Contents:

  1. How to get 100% ADA compliance result in accessibility checker website https://webaccessibility.com? [closed]
  2. jQuery doesn’t give a proper output, but gives these [closed]
  3. fixing slider on my website [closed]
  4. contenteditable change events
  5. Avoid dropdown menu close on click inside
  6. How to properly use jsPDF library
  7. How to get the element clicked (for the whole document)?
  8. How to clear the contents of an iFrame from another iFrame
  9. Prevent form redirect OR refresh on submit?
  10. How to Use Sockets in JavaScript\HTML? [closed]
  11. execCommand() is now obsolete, what’s the alternative?
  12. How to create a custom scrollbar on a div (Facebook style)
  13. jQuery: get data attribute
  14. get the text content from a contenteditable div through javascript
  15. Web app in tvOS
  16. HTML book-like pagination
  17. Inlining ECMAScript Modules in HTML
  18. Passing mouse clicks through an overlaying element
  19. Jquery Event Not Triggering for DOM Elements Created after page load [duplicate]
  20. Does HTML Hidden control have any events? Like onchange or something?
  21. How to resize Twitter Bootstrap modal dynamically based on the content
  22. How to bind click event to object tag?
  23. how to draw a wheel of fortune?
  24. Passing javascript variables between pages [duplicate]
  25. How to create dynamically
  26. Why does
  27. How to create a “show more” button and specify how many lines of text can be initially shown
  28. A way to scroll an underlying div when mouse is on top of a fixed div?
  29. JavaScript form submit WITH a field called submit
  30. Why is iframe.contentWindow == null?

Leave a Comment