Answers

• kthorngren Posts: 20,309Questions: 26Answers: 4,769

  March 2023 Answer ✓

  Its possible that you are executing the showNumberOfRecords function before Datatables has completed initialization. The ajax request is asynchronous so the code keeps executing while waiting for the ajax response. Move the call to this function into the initComplete option.

  Kevin
• JonasNJ Posts: 2Questions: 1Answers: 0

  March 2023

  @kthorngren Kevin, my man, that did the trick. Thank you, I truly appreciate it.

  For anyone experiencing the same issue, here is my updated code:

  // Private functions
          var initDatatable = function () {
              dt = $("#" + param_dataTableID).DataTable({
                  searchDelay: 500,
                  processing: true,
                  serverSide: false,
                  stateSave: true,
                  ajax: {
                      url: param_apiURL,
                      dataSrc: 'data'
                  },
                  columns: param_columns,
                  columnDefs: param_columnDefs,
                  // Extract and show total number of records after initialization
                  initComplete: function(settings, json) {
                      var currentTable = $("#" + param_dataTableID).DataTable();
                      var info = currentTable.page.info();
                      $('#table-info-total-records').html(
                          'You have a total of '+info.recordsTotal+' employees'
                      );
                  }
              });
  
              table = dt.$;
  
              // Re-init functions on every table re-draw -- more info: https://datatables.net/reference/event/draw
              dt.on('draw', function () {
                  KTMenu.createInstances();
              });
          }