Answers

• kthorngren Posts: 21,336Questions: 26Answers: 4,953

  September 2021

  See if setting columns.type to string resolves the issue. The Datatables automatic type detection might be detecting that column as a date.

  Kevin
• Filipe_Apostolo Posts: 4Questions: 1Answers: 0

  September 2021

  Thanks kthorngren,
  I read your answer and tried.
  However I forced the columns to be trated as string:

   $(document).ready( function () {
          $('#datatablesSimple').DataTable(
              {
                  "columns": [
                  { "type": "string" },
                  { "type": "string" },
                  { "type": "string" },
                  { "type": "string" },
                  { "type": "string" },
                  { "type": "string" },
                  { "type": "string" },
                  { "type": "string" }
                  ]
              }
          );
      } );
  

  The column is ordered as the previews picture
• Filipe_Apostolo Posts: 4Questions: 1Answers: 0

  September 2021

  Well I've understood, what happens!! It was so obvious that I wasn't seeing...

  When it does not match any of the automatic type detection ti falls back to string as explained here https://datatables.net/reference/option/columns.type

  However when it is a string the ordering will consider 7 higher than 45 ahahaha, 7 is higher than char 4 duh. it will not work using string as data type
• Filipe_Apostolo Posts: 4Questions: 1Answers: 0

  September 2021

  After some experiments, in which i tried to place the total as tooltip , using column_type as htm-num-fmt, and other combinations without success I quited and used str_pad to format the string with leading zeros.

   str_pad($currentMonth,3,'0',STR_PAD_LEFT).'/'.$totalYear
  

  Output:
  
• kthorngren Posts: 21,336Questions: 26Answers: 4,953

  September 2021

  Don't know if either of these will work for your case but you might try the any-number or natural sorting plugins. You can create your own sorting plugin. Or maybe just using orthogonal data, similar to what you did above, will work.

  If you want help with any of these please provide a simple test case with an example of your data.
  https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

  Kevin