Update only one column data on call of an event somewhere in page, don't want to reload whole data..

sachin_malik

My data table is getting data from a ajax call response, I want to update only one column data on call of an event, just that column data should be reloaded, Not the whole data as it's a big table and reloading whole data again n again will affect my page performance.

colin

That's not possible, as the ajax.reload() will reload the entire table. If you use serverSide, only the data for the current page will be refreshed, so for a large data set, that would be the way to go,

Colin

sachin_malik

got it, cells api can be used for this.
dt.cells(null, 'column_name:name').invalidate() , this will update single column data.

https://datatables.net/reference/api/cells()