Difficulties in ordering data

Difficulties in ordering data

rdorvalrdorval Posts: 1Questions: 0Answers: 0
edited June 2012 in DataTables 1.9
Hello!
I'm having a hard time getting certain types of sorting data using DataTables 1.9 because I am new in this community (I live in Brazil).
I am having trouble ordering fields of type number, currency (Brazilian format, example: R $ 95.50) and date (in dd / mm / yyyy).
What intrigues me most is the ordering of numbers! In my case, if the numbers appear in the list 20,2,10,15,3 it shows this:
10
15
2
20
3
How to fix this? And how to implement the other formats?

Replies

  • allanallan Posts: 63,498Questions: 1Answers: 10,471 Site admin
    You'll need a sorting plug-in since your data contains non-numerical data, but you want it to sort numerically. There are a number of plugs-in here: http://datatables.net/plug-ins/sorting - have a look in-particular at the currency one.

    Allan
This discussion has been closed.