How to refresh Datatable data from js array of objects

Question

I'm using the jquery DataTables plugin to display an array of objects. I would like to clear the table and redraw using the changed data. However, the only way I've been able to do that so far is to destroy the table and reinitialize. I'd like to know if there is a simple way to refresh from JS data source. This is what I'm doing, it works but feels wrong...

if (NAMESPACE.table){
  NAMESPACE.table.destroy();
}

NAMESPACE.table = $('#assets-table').DataTable({
  "data": filteredData,
  "columns": [
      { "data": "id" },
      { "data": "type" },
      { "data": "city" },
      { "data": "state"}
  ]
 });

Nerdroid · Accepted Answer · 2015-01-06 08:35:52Z

6

if you want to clear the data present in dataTable simply call table.clear() it clears all cells in table.

and then add new data using table.row.add().draw();

table.destroy() does not removes data present in cell of table, it only destroys the current instance of dataTable you created.

edited Jan 6, 2015 at 8:35

Nerdroid

14.1k5 gold badges62 silver badges72 bronze badges

answered Jan 6, 2015 at 8:14

Ravi Shankar Gautam

611 silver badge1 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

Piotr Kula Over a year ago

It seems so inefficient to do that, clearing everything when you just want to add a row any way. The problem is I want the user to remove items, then probably this is the only way, since there is no table.row.remove API which is a bit weird to me? But I just needed somebody to say this is the only way.. so here we go. Thanks +1

f p · Accepted Answer · 2014-10-27 16:20:09Z

5

Make it simpler:

NAMESPACE.table = $('#assets-table').DataTable({
  "data": filteredData,
  "columns": [
      { "data": "id" },
      { "data": "type" },
      { "data": "city" },
      { "data": "state"}
  ],
 "destroy": true
 });

answered Oct 27, 2014 at 16:20

f p

3,2431 gold badge30 silver badges36 bronze badges

2 Comments

Gregism Over a year ago

Nice, that is cleaner.

Muhammad Raheel Over a year ago

Great Solution!!

Collectives™ on Stack Overflow

How to refresh Datatable data from js array of objects

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related