Answers

• tangerine Posts: 3,365Questions: 39Answers: 395

  June 2017

  Did you follow the diagnostics at the "more information" link?
• Dalder Posts: 30Questions: 12Answers: 1

  June 2017 edited June 2017

  Yes I did.

  Swapping the values result in the same error.
  Logging the values shows that it is correct and not coming across as undefined/null etc.

  In my actual table there are values after the problem column also, which get populated correctly.

  It looks like the sort criteria on that column may be to blame, but I don't know why.
• allan Posts: 63,516Questions: 1Answers: 10,472 Site admin

  June 2017

  It looks like the sort criteria on that column may be to blame

  Yup. Because you are using orthogonal data DataTables will store the data in the following form:

  {
      "0": "001",
      "1": "Task #1",
      "2": "100",
      "3": {
          "display": "6th June 10:00",
          "@data-order": "1496739600000"
      },
      "4": "2017/06/06"
  }
  

  If you change the row.add() data structure to look like that it will work nicely.

  The other option is to construct a tr element in the same form as the original rows in the table and feed that into row.add(). DataTables will be happy to take the tr element as well.

  Allan
• allan Posts: 63,516Questions: 1Answers: 10,472 Site admin

  June 2017

  DataTables will be happy

  Hmmm - I wonder if that makes DataTables self-aware... There's a scary thought.
• kthorngren Posts: 21,337Questions: 26Answers: 4,954

  June 2017 edited June 2017

  Posted after Allan and my answer wasn't correct

  Kevin
• Dalder Posts: 30Questions: 12Answers: 1

  June 2017

  Thanks for the explanation allan, I changed my script to the object format you provided and I'm no longer getting the error, but the "display" value doesn't seem to be coming through, it's just showing up as blank? Even if I copy and paste your example straight in as such:

  $('#example').DataTable().row.add({
      "0": "001",
      "1": "Task #1",
      "2": "100",
      "3": {
          "display": "6th June 10:00",
          "@data-order": "1496739600000"
      },
      "4": "2017/06/06"
  }).draw();
  

  It still doesn't come through - any ideas?

  Here's an updated link: http://live.datatables.net/johenazi/1/
• allan Posts: 63,516Questions: 1Answers: 10,472 Site admin

  June 2017

  I'll be honest, I'm not sure why that isn't working! Let me dig through that and I'll get back to you.

  Allan
• allan Posts: 63,516Questions: 1Answers: 10,472 Site admin

  June 2017 Answer ✓

  I suspect that there is a bug in this logic. I haven't dug into it yet, but I've made to note to do so.

  In the mean time, to get you up and running, here is how you can do it with a note: http://live.datatables.net/johenazi/5/edit .

  Allan
• Dalder Posts: 30Questions: 12Answers: 1

  June 2017

  Thanks Allan, your temporary fix is doing the trick.

  I'm going to mark this thread as answered and keep my eyes peeled for that bug fix!

  DataTables will be happy