Answers

• kthorngren Posts: 20,275Questions: 26Answers: 4,765

  February 2017

  Your table has 3 columns but you define 6 in DataTables. Add 3 more columns and it should work.

  Kevin
• ghenne Posts: 3Questions: 1Answers: 0

  February 2017

  Are you sure? From the docs on the Destroy function:

  This function can be useful if you require to destroy and create new tables based on new criteria with different initialisation settings or a different number of columns in the table, as they cannot be change on-the-fly through the API.
• kthorngren Posts: 20,275Questions: 26Answers: 4,765

  February 2017 edited February 2017 Answer ✓

  I see. You are using the destroy which allows for changing the Datatables options but doesn't create a new table. If you want to create a new table then you will need to use both destroy and empty. Similar to the second example:
  https://datatables.net/reference/api/destroy()#Examples

  Kevin
• ghenne Posts: 3Questions: 1Answers: 0

  February 2017

  That was it - thank you. Here is the working code:

  function updateTable() {
      table = $('#DataTable1').DataTable();
      table.destroy();
      $('#DataTable1').empty();
      
      table = $('#DataTable1').DataTable( {
          data: dataSet,
          destroy: true,
          empty: true,
          columns: [
              { title: "Name" },
              { title: "Position" },
              { title: "Office" },
              { title: "Extn." },
              { title: "Start date" },
              { title: "Salary" }
          ]
      } );
  }