Answers

• jxuereb Posts: 3Questions: 1Answers: 0

  April 1

  Direct link
  https://datatables.net/examples/advanced_init/row_grouping.html
• kthorngren Posts: 21,853Questions: 26Answers: 5,050

  April 1 edited April 2

  Using table.order() will only return current table order in an array. Adding [0] will return the first element of the returned array. To change table the order you will need to pass in the column index and the direction to the order() API. See the docs for details.

  Go to the example you linked to and paste this into the browser's console:

  $('#example').DataTable().order( [2, 'desc'] ).draw();
  

  You will see the Office column, index 2, change from ASC to DESC order.

  Kevin
• jxuereb Posts: 3Questions: 1Answers: 0

  April 2

  Okay yes you're right, that would fix the example.

  On that example page if you sort by age and query order()[0] it returns [3, 'asc']
  but if you sort by the row grouping and query order()[0] it only returns 2.

  

  Doing the same with order() and you can see that when sorting by any other column you get an array of an array but for the group sorting you get just a single array.

  

  The example code line 31 should simply be:

  var currentOrder = table.order();
  

  and get the intended effect of being able to switch back to descending.
• kthorngren Posts: 21,853Questions: 26Answers: 5,050

  April 2 edited April 2

  Now I understand the problem you are trying to fix. This form of the API uses a 1D array:

  $('#example').DataTable().order( [2, 'desc'] ).draw();
  

  Which is a different structure than the 2D array that results from using the order option or when clicking a column to sort. To keep the same structure use a 2D array, like this:

  $('#example').DataTable().order( [[2, 'desc']] ).draw();
  

  You can copy this code into the example's console to see that this change works:

  var groupColumn = 2;
  
  $('#example tbody')
    .off('click', 'tr.group')
    .on('click', 'tr.group', function () {
      var table = $('#example').DataTable();
      var currentOrder = table.order()[0];
      if (currentOrder[0] === groupColumn && currentOrder[1] === 'asc') {
          table.order( [[groupColumn, 'desc']] ).draw();
      }
      else {
          table.order( [[groupColumn, 'asc']] ).draw();
      }
  });
  

  @allan will need to update the example code to change from a 1D array to a 2D. Changes are needed only on lines 9 and 12 for the example code.

  Kevin
• kthorngren Posts: 21,853Questions: 26Answers: 5,050

  April 3 edited April 3

  I created this PR for the changes to the example code.

  Kevin
• allan Posts: 64,246Questions: 1Answers: 10,602 Site admin

  April 3

  PR pulled in - many thanks for it Kevin!

  It should be that using a 1D array as a setter doesn't impact the return from order() - it is a bug that it does! There is already a fix for this in the 2.3 branch which I hope to release later this month.

  Allan
• kthorngren Posts: 21,853Questions: 26Answers: 5,050

  April 3

  I didn't realize there was a bug fix for using 1D arrays in 2.3. I guess the example doesn't need to be changed Either way you want to go is fine.

  Kevin