Title: Sorting issue (past 10)
Last modified: August 21, 2016

---

# Sorting issue (past 10)

 *  Resolved [MortenJensen](https://wordpress.org/support/users/mortenjensen/)
 * (@mortenjensen)
 * [13 years ago](https://wordpress.org/support/topic/sorting-issue-past-10/)
 * Hello,
 * Thank you for the plugin. It’s a wonderful tool.
 * I have an issue, however.
 * [http://www.fullcourt.dk/nba-free-agent-tracker-2013/](http://www.fullcourt.dk/nba-free-agent-tracker-2013/)
 * If you look at the tab “Erfaring”, you’ll see every number past 10 is sorted 
   differently. I fear the same will happen to “kontrakt” (contract) when I start
   filling those out.
 * And I did download and activate your DataTables Sorting plugins Extension.
 * What to do?
 * Thank you!
 * [http://wordpress.org/extend/plugins/tablepress/](http://wordpress.org/extend/plugins/tablepress/)

Viewing 7 replies - 1 through 7 (of 7 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [13 years ago](https://wordpress.org/support/topic/sorting-issue-past-10/#post-3739743)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * The reason for this is that the content in the “Erfaring” column is not numeric,
   but strings (because of the the “år” after each value. And as strings are sorted
   differently than numbers, you get this result.
    To fix this, you’ll either have
   to remove all ” år” from that column, or (as you have already installed the 
   DataTables Sorting Plugins Extension), add this to the “Custom Commands” textfield
   on the “Edit” screen of the table:
 *     ```
       "aoColumnDefs": [ { "sType": "formatted-num", "aTargets": [ 3 ] } ]
       ```
   
 * (The 3 in the code indicates that this shall apply to the fourth column, as counting
   starts with 0.)
    To later also fix the sorting for the “Kontrakt” column, change
   that code to
 *     ```
       "aoColumnDefs": [ { "sType": "formatted-num", "aTargets": [ 3, 7 ] } ]
       ```
   
 * Regards,
    Tobias
 *  Thread Starter [MortenJensen](https://wordpress.org/support/users/mortenjensen/)
 * (@mortenjensen)
 * [13 years ago](https://wordpress.org/support/topic/sorting-issue-past-10/#post-3739749)
 * Hello Tobias,
 * Thank you very much. It solved the “erfaring” part. I tried to include the 7th
   column, and inserted a few raw contract numbers just to test it out, but nothing
   happened.
 * Is it because the dollar sign is the first symbol?
 * Thank you!
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [13 years ago](https://wordpress.org/support/topic/sorting-issue-past-10/#post-3739844)
 * Hi,
 * sure, no problem! You are very welcome!
 * For the “Kontrakt” column: You’ll need to add more values, otherwise you can’t
   see if the sorting works.
 * Regards,
    Tobias
 *  Thread Starter [MortenJensen](https://wordpress.org/support/users/mortenjensen/)
 * (@mortenjensen)
 * [13 years ago](https://wordpress.org/support/topic/sorting-issue-past-10/#post-3739901)
 * Oh okay, so I need to basically fill that entire column out for it to be sortable?
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [13 years ago](https://wordpress.org/support/topic/sorting-issue-past-10/#post-3739902)
 * Hi,
 * yes, that might be necessary for the external sorting script to work.
 * Regards,
    Tobias
 *  Thread Starter [MortenJensen](https://wordpress.org/support/users/mortenjensen/)
 * (@mortenjensen)
 * [13 years ago](https://wordpress.org/support/topic/sorting-issue-past-10/#post-3739905)
 * Okay, thank you very much Tobias!
 * Have a good one.
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [13 years ago](https://wordpress.org/support/topic/sorting-issue-past-10/#post-3739908)
 * Hi,
 * sure, no problem! You are very welcome!
 * Best wishes,
    Tobias
 * P.S.: In case you haven’t, please [rate TablePress](http://wordpress.org/support/view/plugin-reviews/tablepress)
   here in the plugin directory. Thanks!

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Sorting issue (past 10)’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 7 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [13 years ago](https://wordpress.org/support/topic/sorting-issue-past-10/#post-3739908)
 * Status: resolved