Answers

• kthorngren Posts: 21,341Questions: 26Answers: 4,954

  July 24 edited July 24

  You aren't using Datatables API's to update the table so Datatables doesn't know about the changes. See this FAQ for more info.

  Looks like you will want to use clear() to clear the Datatable followed by rows.add() to add the new rows in place of $('.orderList').empty().append(dataSet).DataTable();

  Kevin
• OKSosume Posts: 4Questions: 1Answers: 0

  July 24 edited July 24

  The data that comes back from the PHP server is filled originally with this:
  script

  <div>
      <table class="row-border cell-border stripe orderList"></table>
  </div>
  PHP
      <script type="text/javascript">
          $.ajax(
              'CloverDriver.php',
              {
                  success: function (dataSet)
                  {
                      $('.orderList').empty().append(dataSet).DataTable({order: [[3, 'desc']], paging: false});
                  },
                  error: function () {
                      alert('There was an error getting data from the payment processor');
                  }
              }
          );
  

  The data from PHP comes back as the html table data.
  That initial data allows me to loop through the rows.

  However, when I make another call to get "all" of the data, the table is filled exactly the same way AND the DataTable displays the rows but, I cannot loop through them. It implies there are no rows.
• OKSosume Posts: 4Questions: 1Answers: 0

  July 24

  I can set up a teams session to work with someone that I can pay to get this resolved.
  If that is an improper comment, I apologize in advance.
• kthorngren Posts: 21,341Questions: 26Answers: 4,954

  July 24 Answer ✓

  Another option is to use destroy() before you clear the table and repopulate the data. Use DataTable.isDataTable() to see if its already a Datatable before destroying. Something like this:

  if (!DataTable.isDataTable('.orderList')) {
      $('.orderList').DataTable().destroy();
  }
  
  $('.orderList').empty().append(dataSet).DataTable();
  

  This should reinitialize the Datatable with the new table data.

  You can use rows().every() to loop through the rows.

  If you still want to setup support access contact @allan by clicking the Ask a Private Question button at the top of this page.

  Kevin
• OKSosume Posts: 4Questions: 1Answers: 0

  July 24

  Thank you, Destroying the table first worked perfectly. I tried to click 'yes' on 'Did this answer the question?' but it says I don't have permission to do that.
• allan Posts: 63,516Questions: 1Answers: 10,472 Site admin

  July 24

  That's odd - it looks like it went though and has marked Kevin's reply as the answer... I'll keep an eye on that.

  Allan