Answers

• JPaulB Posts: 3Questions: 0Answers: 0

  June 2016 edited June 2016

  Hi,
  I've been having the same issue. I solved this by simply initializing the dataTable at the moment of the user action.
  So basically instead of initializing your dataTable at e.g. (document).ready you could do it after a user submits his request (in your case the search conditions etc.)
  Something like so

  //globally available variable for your dataTable
  var table = null;
  
  $('#mySubmit').on('click',function(){
       //your validation and search conditions here ...
  
      //it is important that you destroy the table before initializing it again
       if(table != null){ 
            table.destroy();
       }
  
      table = $('#myTable').DataTable({
          ajax : {
           "url": "/myUrl.htm"
           // further arguments to "ajax" 
           }
      })
  })
  
  

  Hope it helps.
  Paul
• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  June 2016

  The other option is to make your own Ajax call and then use rows.add() to add the rows - i.e. bypass DataTables' own ajax options.

  Allan