Datatables Custom Filters — Server Side Ajax

Datatables Custom Filters — Server Side Ajax

Materials
* Bootstrap v3.3.6
* DataTables 1.10.11
* jQuery v2.2.4
* Select2 4.0.5
* Date Range Picker 3.1

We have prepared this tutorial in Datatables to teach you how to filter your data as you wish.

Filtering has 3 different methods

• Default Search (Datatables Search feature)
• Filter by Category Name
• Filter by Date Range

// Default Datatables JS Codes
tableName = 
   $('#dynamic-table').DataTable( {
    "ordering": false,
    "processing": true,
    "serverSide": true,
    "stateSave": true,
    "ajax":{
     url :"ajax_query.php",
     type: "post",
     error: function(){}
    },
    "lengthMenu": [ 10, 25, 50, 75, 100,1000 ],
     'columnDefs': [{
     'targets': 0,
     'searchable': false,
     'orderable': false,
     'className': 'center',
     'render': function (data, type, full, meta){
      return '<label class="pos-rel"><input type="checkbox" name="id[]" value="'+data+'" class="ace" /><span class="lbl"></span></label>';
     }
     }
    
     ],
     'order': [[1, 'asc']],
    select: true,
    select: {
     style: 'multi',
     selector: 'td:first-child',
     info: false
    },
    "fnInitComplete": function(oSettings, json) {
     // Load Compmplete Functions
    },
    "drawCallback": function( settings ) {
     // Callback…