Event based DT refresh via fnDestroy (then re-init) and fnDataTablesPipeline incompatiblity issue

hsajjad

Hi,

In my use-case I have various search criteria fields that are submitted to server side when user presses a button. DT need be refreshed for each submission..

The approach I'm using is to fnDestroy and re-init the entire DT post each form submission - would like to ratify if this is the correct approach? Ideally should just able to refresh the existing table anew, and tried using the fnAjaxReload, but couldn't get that to work.


Current approach:
[code]
$(document).ready(function() {
var oTable;
$('#runQ').click( function() {
if(oTable)
{
oTable.fnDestroy();
}
var sData = $('input').serialize();
oTable = $('#table_id').dataTable( {
"bProcessing": true,
"bServerSide": true,
"bDestroy": true,
"sAjaxSource": "query.do?"+sData,
...
[/code]

Issue:

I can't use the excellent pipelining plugin in DT, due to some built-in caching in that? My table data stay old/stale when I use this plugin, however, I'm keen to get that to work as my data size is quite big and therefore would like to bulk load data on each server side trip.

Any expert advice/comments on how to address this challenge?

Thanks in advance!