Answers

• kthorngren Posts: 21,546Questions: 26Answers: 4,988

  April 2020

  Its hard to find but Allan shows how to align the columns in this thread. For example:
  http://live.datatables.net/gupazase/1/edit

  Kevin
• geebeetoo Posts: 26Questions: 6Answers: 0

  April 2020 edited April 2020

  Thank you for that. It almost works with that solution.

  I use an ajax call to get the data from server side. My problem is I don't know how to return the response from ajax to the format() function with just the many <tr> nodes.

  I can return the response but it ignores the $(msg).toArray();

  I am using the example :
  CODE:
  function format ( rowData ) {
  var div = $('

  ')
  .addClass( 'loading' )
  .text( 'Loading...' );

  $.ajax( {
      url: '/myAjaxCall',
      success: function ( msg ) {
          div
              .html( msg )
              .removeClass( 'loading' );
      }
  } );
  
  return $(div).toArray();
  

  }
  END CODE

  but this does not eliminate the colspan that mucks things up.

  I tested returning this:
  newRows = "<tr><td class='expand-row'></td><td class='theSubjectTD' style='min-width:150px'>TESTING THIS ROW 22222</td><td>0:07:34</td><td>0</td><td>0:00:00</td><td>0:00:04</td><td>4</td><td>0</td><td>0</td><td>0</td><td>450</td><td>0</td><td>(0.00 %)</td><td>(0.00 %)</td><td>0:00:00</td><td>0:00:00</td><td>0</td><td>(0.00 %)</td><td>0:00:00</td></tr><tr><tr><td class='expand-row'></td><td class='theSubjectTD' style='min-width:150px'>TESTING THIS ROW 33333</td><td>0:07:34</td><td>0</td><td>0:00:00</td><td>0:00:04</td><td>4</td><td>0</td><td>0</td><td>0</td><td>450</td><td>0</td><td>(0.00 %)</td><td>(0.00 %)</td><td>0:00:00</td><td>0:00:00</td><td>0</td><td>(0.00 %)</td><td>0:00:00</td></tr><tr>";
  return $(newRows).toArray();

  And that works. But I can't figure how to use the 'msg' from ajax callback and return properly given the example code from your site.
• geebeetoo Posts: 26Questions: 6Answers: 0

  April 2020

  In the example above under newRows variable, I copied the string of <tr> nodes wrong here. it should have been

  newRows = "<tr><td class='expand-row'></td><td class='theSubjectTD' style='min-width:150px'>TESTING THIS ROW 22222</td><td>0:07:34</td><td>0</td><td>0:00:00</td><td>0:00:04</td><td>4</td><td>0</td><td>0</td><td>0</td><td>450</td><td>0</td><td>(0.00 %)</td><td>(0.00 %)</td><td>0:00:00</td><td>0:00:00</td><td>0</td><td>(0.00 %)</td><td>0:00:00</td></tr><tr><td class='expand-row'></td><td class='theSubjectTD' style='min-width:150px'>TESTING THIS ROW 33333</td><td>0:07:34</td><td>0</td><td>0:00:00</td><td>0:00:04</td><td>4</td><td>0</td><td>0</td><td>0</td><td>450</td><td>0</td><td>(0.00 %)</td><td>(0.00 %)</td><td>0:00:00</td><td>0:00:00</td><td>0</td><td>(0.00 %)</td><td>0:00:00</td></tr>";

  This latter is what I tested and it works perfect.

  I just need to figure how to send the ajax results to the format() function properly.
• geebeetoo Posts: 26Questions: 6Answers: 0

  April 2020

  PS This is probably important for you to know.
  When the page loads the data for main table comes directly from a server side php call, not an ajax call.

  The ajax call is only used when we need details of given row.
• geebeetoo Posts: 26Questions: 6Answers: 0

  April 2020

  EUREKA!

  I got it to work.

  I had to bring my ajax call in the click details-control function.

  Thanks for your help.