Easy search filters for Datatables
Custom search filters for Datatables
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>Filter :</label>
<input type='text' value='' class='filter'>
</div>
</form>
<table id="example" class="display" cellspacing="0" width="100%">
<thead>p
<tr>
<th>Name</th>
<th>Position</th>
<th>Office</th>
<th>Reject</th>
<th>Approvd</th>
<th>Salary</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Name</th>
<th>Position</th>
<th>Office</th>
<th>Reject</th>
<th>Approvd</th>
<th>Salary</th>
</tr>
</tfoot>
<tbody>
<tr>
<td>Tiger Nixon</td>
<td>System Architect</td>
<td>Edinburgh</td>
<td>Pending</td>
<td>Pending</td>
<td>$320,800</td>
</tr>
<tr>
<td>Garrett Winters</td>
<td>Accountant</td>
<td>Tokyo</td>
<td>Pending</td>
<td>Approved</td>
<td>$170,750</td>
</tr>
<tr>
<td>Ashton Cox</td>
<td>Junior Technical Author</td>
<td>San Francisco</td>
<td>Rejected</td>
<td>Pending</td>
<td>$86,000</td>
</tr>
<tr>
<td>Cedric Kelly</td>
<td>Senior Javascript Developer</td>
<td>Edinburgh</td>
<td>Pending</td>
<td>Pending</td>
<td>$433,060</td>
</tr>
<tr>
<td>Jennifer Acosta</td>
<td>Junior Javascript Developer</td>
<td>Edinburgh</td>
<td>Rejected</td>
<td>Pending</td>
<td>$75,650</td>
</tr>
<tr>
<td>Cara Stevens</td>
<td>Sales Assistant</td>
<td>New York</td>
<td>Pending</td>
<td>Pending</td>
<td>$145,600</td>
</tr>
<tr>
<td>Hermione Butler</td>
<td>Regional Director</td>
<td>London</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() {
alert('lalala');
dtable
.column(3).search(this.value)
.column(4).search(this.value)
.draw();
});
$(".dataTables_filter input").on('keyup change', function() {
alert('blablabla');
//clear column search values
dtable.columns().search('');
//clear input values
$('.filter').val('');
});
});