Answers

• colin Posts: 15,177Questions: 1Answers: 2,590

  January 2022

  That's good English, far better than my German!

  To do this, you would use orthogonal data - this example here demonstrates that. You'll see the "Rarity" column is a string, but a number is returned within columns.render to ensure they're ordered appropriately.

  Colin
• hkuesters Posts: 9Questions: 4Answers: 0

  January 2022

  Hi Colin!
  Thanks for your post!
  I've understand the idea behind, but it doesn't work. I have made an example with 100 datasets: Example-Link As you can see, is works not correctly. The column "AKL" does not sort the datasets in the given order.
  Or have I done anything wrong?
  Bye
  Hubert
• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  January 2022 edited January 2022

  Its hard to visualize the problem so I copied your switch block to show the orthogonal data generated for the display type. Sort the AKL column and you will see the last 3 rows are:

  O45 19
  U07-2 2
  U09-1 3
  

  The Datatables type detection has set the column type to string. When sorting string 2 does come after 19. You need to have columns.render set the type to the data type you are returning or the sort operation. Change if (type === 'sort') { to if (type === 'sort' || type === 'type') {. Toggle the comment of these 2 statements in the example to see that sorting is now working.

  http://live.datatables.net/memikati/1/edit

  Kevin
• hkuesters Posts: 9Questions: 4Answers: 0

  January 2022

  Hi Kevin!
  Thank you very much! Now it works!
  That was the last step to the right solution!
  Have a nice day - greetings from Brazil
  Hubert