Answers

• allan Posts: 63,519Questions: 1Answers: 10,473 Site admin

  September 2019

  I have found that updating the object does not update the table.

  Correct. DataTables doesn't "observe" changes on objects. You need to tell DataTables that the data in the object has changed either through the row().invalidate() or cell().invalidate() methods (or their plural versions - e.g. table.rows().invalidate().draw() will reread the data source for all rows).

  Allan
• Karl_S Posts: 20Questions: 6Answers: 0

  September 2019

  Thank you for that direction, Alan, It works well for a changed object. But it doesn't seem to work if an object is added to add another row. So I am guessing I need to use either row().add() or rows().add() to add the new object items to the table. I tried using
  $('#myTable').DataTable().rows().invalidate(workStudyPositions.Canada.current).clear().draw()
  but ended up with an empty table. Same if I do not pass the object to rows.().invalidate().
  I do currently have it changing any items in the object which I change, just not adding additional rows, so I am close. I will also need to possibly delete rows. I thought a redraw based on the objects contents should do this but cannot figure that out.
• colin Posts: 15,240Questions: 1Answers: 2,599

  September 2019

  Hi @Karl_S ,

  but ended up with an empty table

  Yep, you're selecting all rows (no args to rows()), then clear() clears the table of all data. Also, invalidate() doesn't take an arg list that, see usage.

  Try breaking the joined methods, that'll help to understand their usage.

  Cheers,

  Colin
• Karl_S Posts: 20Questions: 6Answers: 0

  September 2019

  So which piece do I use after clear to recreate the table with the current version of the object including possible additional row(s)? Currently I am doing this to add 1 row after editing any of the items in the original object and adding the information to the object as well:

  $("#myTable").DataTable().row.add(objThisPosition);
  $("#myTable").DataTable().rows().invalidate().draw();
  

  or, if there are multiple new rows, use:

  $("#myTable"').DataTable().rows().add(objThesePositions).invalidate().draw();
  

  But I would rather just add and edit the original object
• allan Posts: 63,519Questions: 1Answers: 10,473 Site admin

  September 2019

  I'm not clear on why you would add a row and then attempt to immediately invalidate it and the other rows in the table. If you have an object instance that you have changed properties of, just invalidate that individual row.

  Here is a little example: http://live.datatables.net/tikaxozo/1/edit

  After 1 second I update the allan instance to change the name and then use rows().invalidate() to tell the table that it needs to reread the data. I could have it update on a specific row, but I've been a touch lazy there ;-).

  Allan
• Karl_S Posts: 20Questions: 6Answers: 0

  September 2019

  If I am editing a row and adding a row (because of actions which happened elsewhere) then I need to get both the edited data and the added row into the table. I could keep track of and invalidate the row instead of the entire table but I may have multiple rows change. So I apparently need to add the row(s) to get them in and then invalidate the table to get the edited items in. And if I delete a row I would need to do that inside there as well, but I think I may end up just hiding these based on an Ignore column being set to true.

  I was looking to save any changes and edit the table(s). I imagine you are expecting that I would send edits to an effected table(s) with each possible change. Honestly I have not decided when the change occurs but I was thinking after data is sent to the server and the server responds with acknowledgement of the change. Otherwise I need to back things out if an error in the save occurs.

  Karl