1.10 Sort Column with Numbers and empty Cells

1.10 Sort Column with Numbers and empty Cells

choggerchogger Posts: 15Questions: 4Answers: 0

Hello Community,

i need help with sorting numbers in a column with a few empty entries. I want the empty cells allways at the bottom when sorting the table.

I found a few posts here with the same problem and got a few solutions but nothing worked here...
For example the numWithNull example from here (http://datatables.net/forums/discussion/9784/sort-columns-with-numbers-and-empty-cells) is not working

Here is an example (test) page

http://chogger.de/work/?p=track_detail_records&id=101

The columns "Race" and "Qualy" are the columns where i need this behavior.
Any help would be grear

Answers

  • allanallan Posts: 61,743Questions: 1Answers: 10,111 Site admin

    I want the empty cells allways at the bottom when sorting the table.

    You will need to create an ordering plug-in that does this in that case. The -asc and -desc functions can be defined to perform different logic on each sorting direction.

    Allan

This discussion has been closed.