Answers

• kthorngren Posts: 22,368Questions: 26Answers: 5,138

  March 2017 Answer ✓

  The cell-selector can be used to select a specific cell. If you know the specific row and column you could do something like this:

  table.cell({row:2, column:1}).data('New value for row 2 column 1');
  

  Kevin
• ChrisDennis Posts: 12Questions: 5Answers: 0

  March 2017 edited March 2017

  Thanks Kevin -- that partly solves the problem, and got me thinking on the right path.

  I didn't emphasise in my question that I want to iterate across the columns and check which have data to update.

  With a bit of help from Stackoverflow I eventually ended up with this, which relies on the properties of my msg having the same names as the data entries in the table's column definitions. (The columns array also has the name of each column, so it could use those for matching if required.)

  let msg = { id: 1, customer_name: 'Fred' };  // source of updates (from backend)
  let row = table.row('#row-' + msg.id);
  let rowindex = row.index();                                                            
  let columns = table.settings().init().columns;                                      
  table.columns().every(function (colindex) {     
       let coldata = columns[colindex].data;  // 'data' as in the DT column definition
       if (coldata != 'id' && msg.hasOwnProperty(coldata)) {  // (don't update the id!)
           table.cell({row: rowindex, column: colindex}).data(msg[coldata])  
       }                                                                              
  });