Replies

• zgoforth Posts: 493Questions: 98Answers: 2

  August 2020

  @kthorngren I started this new one because I figured I need to describe better in depth what I am trying to do instead of have people assume
• kthorngren Posts: 21,336Questions: 26Answers: 4,951

  August 2020

  You have described what you want to do and I recommended, more than once, that you look at the RowGroup Extension for grouping the rows. You never responded and kept trying the child row details solution. If you want the row details solution then you first need to provide a test case we can work with. I started one for you using your data structure with Javascript data. You can update this to add more rows and look more like your solution. But you have not done that. To learn how to create the solution you want you don't need to fetch the data via Ajax as that is not part of the issue. You just need to supply sample data that is representative of your solution.

  Kevin
• zgoforth Posts: 493Questions: 98Answers: 2

  August 2020

  I followed that and I will attach the picture of how it turned out. It posts the same Deliverable more than once.
• zgoforth Posts: 493Questions: 98Answers: 2

  August 2020

  $(document).ready(function() {
      
    $('#myTable').DataTable( {
      "columns": [
        { "data": "Program" },
        { "data": "Deliverable" },
        { "data": "To" },
        { "data": "Date" },
        { "data": "Approved" },
        { "data": "Notes" }
      ],
      
      dom: 'Bfrtip',
      buttons: [
          'copy','csv','excel','pdf','print'
      ], 
      rowGroup: {
              dataSrc: 'Deliverable'
          }
    } );
      
   loadData();
      
  } );
  
• kthorngren Posts: 21,336Questions: 26Answers: 4,951

  August 2020 edited August 2020

  You need to order by the Deliverables column using order, for example order: [ [1, 'asc'] ],

  Kevin
• zgoforth Posts: 493Questions: 98Answers: 2

  August 2020

  @kthorngren Here. http://live.datatables.net/hoguhequ/1/edit

  
• zgoforth Posts: 493Questions: 98Answers: 2

  August 2020

  I changed to order by Program, and that looks pretty well. Is it possible to have the 5 data cells under the Ammo section to not populate the program column while it is already under the name AMMO? I tried and my table did not like that
• kthorngren Posts: 21,336Questions: 26Answers: 4,951

  August 2020

  Maybe hiding the Program column is what you want. Try using columns.visible, for example:

      "columns": [
        { "data": "Program", visible: false },
  
• zgoforth Posts: 493Questions: 98Answers: 2

  August 2020

  @kthorngren Thank you, lastly is it possible to make these rows collapsible
• kthorngren Posts: 21,336Questions: 26Answers: 4,951

  August 2020 edited August 2020

  There are quite a few threads on this. Start with this thread. You can find threads that ask to display the plus and minus signs like child detail rows. Do a search for rowgroup collapse or variants of that to find some fin stuff to do.

  Kevin