DataTables searching for rendered column
HTML
<script src="http://vitalets.github.com/x-editable/assets/mockjax/jquery.mockjax.js"></script>
<script src="//cdn.datatables.net/1.10.7/js/jquery.dataTables.js"></script>
<link rel="stylesheet" href="//cdn.datatables.net/1.10.7/css/jquery.dataTables.css">
<table id="example" class="display" cellspacing="0">
<thead>
<tr>
<th>A</th>
<th>B</th>
</tr>
</thead>
<tbody></tbody>
</table>
JavaScript
// AJAX emulation
$.mockjax({
url: '/test/0',
responseTime: 200,
response: function(settings){
console.log("Request data: ", settings.data);
var val = settings.data.example_select;
this.responseText = {
data: [
["A01", 1.11],
["A02", 2.12],
["A03", 3.13],
["A04", 4.14],
["A05", 5.51],
["A06", 25.34],
["A07", 23.66],
["A08", 3303.33],
["A09", 55.55],
["A10", 77.77],
["A11", 66.55],
["A12", 1000.00]
]
}
}
});
var $table = $('#example');
$('#example').DataTable({
"ajax": {
url: "/test/0",
},
"columns": [
{ },
{
render: $.fn.dataTable.render.number(',', '.', 2, '$')
}
]
});
$('#example-select').on('change', function(){
$('#example').DataTable().ajax.reload();
});