Order by numer dont work ok

pippuccio76

Hi , i have a datatable with one field as this :
1 of 01-10-2017
2 of 01-10-2017
3 of 01-10-2017
4 of 01-10-2017
5 of 01-10-2017
6 of 01-10-2017
7 of 01-10-2017
8 of 01-10-2017
9 of 01-10-2017
10 of 01-10-2017
11 of 01-10-2017

if i click to sort the 10 and 11 are after 1 ther's a way to ordinat numerically ?

tangerine

That is not numeric data. Can you re-design it in any way?

gyrocode

You can use columns.type and use num to sort your data numerically.

For example:

       columnDefs: [
          { 
             targets: 0,
             type: 'num'
          }
       ]

Replace 0 in targets: 0 with zero-based index of your column.

See this example for code and demonstration.

---

See more articles about jQuery DataTables on gyrocode.com.