Replies

• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  April 2023

  I've tried using the data-order= on its own but it did not work

  The HTML5 orthogonal data options only work with HTML supplied data.

  I've also tried using the render: function()

  Datatables does automatic type detection, see the columns.type docs for details. Type detection still types the column as text. So you need to have Datatables adjust the type based on the orthogonal data by adjusting your if statement, like this if (type === 'sort' || type === 'type') {. See the updated example:
  https://live.datatables.net/jepaluyo/1/edit

  Another option might be the natural sorting plugin.

  Kevin
• Tosti911 Posts: 2Questions: 0Answers: 0

  April 2023

  Thank you for your answer Kevin, I tried something close to your example (but probably a little different) which did not work so it's good to see that I was close. After a few more hours, I managed to find a workaround which was pretty simple. I removed the HTML from the row add and used the render function to show it:

  if (type === 'sort') {
      return parseInt(data.replace(/\D/g,''));
  }
  if (type === 'display') {
      return data + "<sup>Text</sup></td>";
  }
  

  while also passing in the data-order= which seems to do the trick, example: https://live.datatables.net/hesaqano/1/edit

  Thank you again for your answer, it really helped me!