Answers

• trendsic Posts: 7Questions: 2Answers: 1

  August 2019 Answer ✓

  It is possible, but maybe not the way you're wanting? I did this by creating a extra column that allows the user to expand the extra data. I believe I found this page is what helped push me into coming up with the solution below: https://datatables.net/examples/api/row_details.html

  Here's a raw code dump of how I did it. Let me know if you have questions about it:

  $('#tblReport tbody').off('click', 'td.details-control .gimme-more-data');
  $('#tblReport tbody').on('click', 'td.details-control .gimme-more-data', function () {
      $('.nested-table').remove();
      var tr = $(this).closest('tr');
      var row = tbl.row(tr);
  
      if (row.child.isShown()) {
          // This row is already open - close it
          row.child.hide();
          tr.removeClass('shown');
      } else {
          shared.contentLoading(true);
  
          dataservice.getASAPReportDateRange(startDate().replace('/', '-').replace('/', '-') + "/" + endDate().replace('/', '-').replace('/', '-') + "/" + selectedAgentID() + "/" + row.data().AgentId).then(function (data) {
              // Open this row
              row.child('<table id="sub-data" class="bg-white nested-table"></table>').show();
  
              $('#sub-data').DataTable({
                  dom: "t",
                  responsive: true,
                  data: data.ASAPReport,
                  columns: [
                      { data: "AdjustmentDate", title: 'Adjustment Date' },
                      { data: "ApptAgent", title: 'Agent' },
                      { data: "Reason", title: 'Reason' },
                      { data: "Amount", title: 'Amount' },
                  ],
              }).columns.adjust().responsive.recalc();
  
              tr.addClass('shown');
          }).then(function() {
              shared.contentLoading(false);
          });
      }
  });
  
• kthorngren Posts: 21,345Questions: 26Answers: 4,954

  August 2019 Answer ✓

  This thread has some options that may help:
  https://datatables.net/forums/discussion/42045/nested-tables#latest

  Kevin