Easy search filters for Datatables

Custom search filters for Datatables

by Muhammad Mushtaq Sheikh

HTML

<link rel="stylesheet" href="//cdn.datatables.net/1.10.10/css/jquery.dataTables.min.css">
<script src="//cdn.datatables.net/1.10.10/js/jquery.dataTables.min.js"></script>
<script src="http://cdn.datatables.net/plug-ins/1.10.13/api/fnMultiFilter.js"></script>
<form class='filter-form'>
    <h3>Filters</h3>
    <div>
        <label>Name :</label>
        <input type='text' value='' class='filter' data-column-index='0'>
    </div>
     <div>
        <label>Postion :</label>
        <input type='text' value='' class='filter' data-column-index='1'>
    </div>
     <div>
        <label>Office :</label>
        <input type='text' value='' class='filter' data-column-index='2'>
    </div>
</form>
<table id="example" class="display" cellspacing="0" width="100%">
    <thead>
        <tr>
            <th>Name</th>
            <th>Position</th>
            <th>Office</th>
            <th>Age</th>
            <th>Start date</th>
            <th>Salary</th>
        </tr>
    </thead>
    <tfoot>
        <tr>
            <th>Name</th>
            <th>Position</th>
            <th>Office</th>
            <th>Age</th>
            <th>Start date</th>
            <th>Salary</th>
        </tr>
    </tfoot>
    <tbody>
        <tr>
            <td>Tiger Nixon</td>
            <td>System Architect</td>
            <td>Edinburgh</td>
            <td>61</td>
            <td>2011/04/25</td>
            <td>$320,800</td>
        </tr>
        <tr>
            <td>Garrett Winters</td>
            <td>Accountant</td>
            <td>Tokyo</td>
            <td>63</td>
            <td>2011/07/25</td>
            <td>$170,750</td>
        </tr>
        <tr>
            <td>Ashton Cox</td>
            <td>Junior Technical Author</td>
            <td>San Francisco</td>
            <td>66</td>
            <td>2009/01/12</td>
            <td>$86,000</td>
        </tr>
        <tr>
            <td>Cedric Kelly</td>
            <td>Senior Javascript Developer</td>
            <td>Edinburgh</td>
     ...

CSS

.filter-form {
  margin-bottom: 30px; 
}
.filter-form div {
  margin-bottom: 10px; 
}

JavaScript

$(document).ready(function () {

    // DataTable
    var dtable = $('#example').DataTable();

    $('.filter').on('keyup change', function () {
       table
 .column( 0 ).search( 'Edinburgh' )
 .column( 1 ).search( '22' )
 .draw();
    });
    $( ".dataTables_filter input" ).on( 'keyup change',function() {
	   //clear column search values
        dtable.columns().search('');
       //clear input values
       $('.filter').val('');
	});	

});