Carlos Peña
Carlos Peña

Reputation: 11

Refresh datatable data

I am trying to refresh the data from my table, but I am not using ajax and that is why when I try to use table.ajax.reload() it is not working.

It gives me wrong json response since the way I am declaring my table is this:

var table = $('.table').DataTable( {
  "data": global_data,
  "scrollX": true,
  "pagination": false,
  "lengthChange": false,
  "bPaginate": false,
  "language": {
    "url": "http://cdn.datatables.net/plug-ins/1.10.16/i18n/Spanish.json"
  },
  "order": [[ 2, "desc" ]],
});

So in another process I update the variable global_data, how to refresh the data?

Thanks

Upvotes: 1

Views: 1911

Answers (1)

LMoreno10
LMoreno10

Reputation: 73

If you are using datatables you can destroy the data with the following line:

$ ('# mytable'). dataTable (). fnDestroy ();

and fill the table again with the data you want.

var table = $('.table').DataTable( {

  "data": global_data,
  "scrollX": true,
  "pagination": false,
  "lengthChange": false,
  "bPaginate": false,
  "language": {
    "url": "http://cdn.datatables.net/plug-ins/1.10.16/i18n/Spanish.json"
  },
  "order": [[ 2, "desc" ]],
});

Upvotes: 1

Related Questions