Replies

• allan Posts: 63,405Questions: 1Answers: 10,452 Site admin

  August 2010

  What you can do is something like this:
  
  [code]
  $.ajax( {
  "url": 'whatever.php',
  "success": function ( json ) {
  $('#example').dataTable( json );
  },
  "dataType": "json"
  } );
  [/code]
  So you just make the Ajax call "manually" and then use the return to initialise DataTables.
  
  Allan
• WhatEver Posts: 8Questions: 0Answers: 0

  August 2010

  Alan, thanks a lot for the reply. I was thinking in this way but didn't see a way to update the data without destroying/recreating the table (fnAjaxReload, fnDraw won't work, will they?)
• allan Posts: 63,405Questions: 1Answers: 10,452 Site admin

  August 2010

  It depends what you want to do. If you just want to update the data, then yes, fnReloadAjax etc will work great. However, if you want to completely re-initialise the table, then you can use bDestroy:true ( http://datatables.net/usage/options#bDestroy ).
  
  Allan
• WhatEver Posts: 8Questions: 0Answers: 0

  August 2010 edited August 2010

  Sorry, but I didn't quite catch what you meant :(
  
  if I use the code like:
  [code]
  $.ajax( {
  "url": 'whatever.php',
  "success": function ( json ) {
  $('#example').dataTable( json );
  },
  "dataType": "json"
  } );
  [/code]
  
  and I want to update the data from the server (using the AJAX request) what function should I call?
  $('#example').dataTable.fnDraw - seems doesn't work
  $('#example').dataTable.oApi._fnAjaxUpdate - doesn't work either
  fnReloadAjax function - doesn't even exist
  
  or just calling initial AJAX request one more time is enough?
• allan Posts: 63,405Questions: 1Answers: 10,452 Site admin

  August 2010

  Try this:
  
  [code]
  
  $.ajax( {
  "url": 'whatever.php',
  "success": function ( json ) {
  json.bDestroy = true;
  $('#example').dataTable( json );
  },
  "dataType": "json"
  } );
  [/code]
  That will cause DataTables destroy the old table and then initialise it with the new information from the server.
  
  The other option is fnReloadAjax (which is a plug-in: http://datatables.net/plug-ins/api#fnReloadAjax ).
  
  Allan