Sorting of footable column of integers rendering unexpected results due to string sort

Question

I am using footable.js plugin to sort a table in my MVC application. On clicking the row header for a column containing integers values they are being sorted as follows:

81, 811, 776, 700, 70

Is there anything I can do to this library that would enable the sorting of integer columns to be sorted on value:

811,776,700,81, 70

Any help would be greatly appreciated!

Add this as an answer, then in a couple of days accept your answer. It'd help other people with the same problem if they see that your question was answered, even if it was by yourself. — Adrian Wragg, Sep 05 '13 at 21:29

score 6 · Accepted Answer · answered Sep 06 '13 at 11:12

6

data-type="numeric" added to column sorted this

answered Sep 06 '13 at 11:12

Jay

3,012
14
48
99

score 1 · Answer 2 · answered Jun 06 '17 at 06:13

1

In newer releases, data-type="number" will do it.

answered Jun 06 '17 at 06:13

Code

99
1
4

Sorting of footable column of integers rendering unexpected results due to string sort

2 Answers2