Wrong order after sorting

  • Resolved trixox

    (@trixox)


    4 years, 1 month ago

    Hi,

    here you can see, that I suddenly have a wrong order after pressing the sorting button. The site is currently running on a staging site so I am not able to show you the link.

    After File M-094 it proceeds with M-1000 and then again to M-102. M-102 should be directly after M-094, so that it has a logical order.

    See video here: https://imgur.com/ntI1muF

    How to proceed?

Viewing 1 replies (of 1 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    The cause for this is the “M-” part in these cells. These change the sorting of that column from “numeric” sorting (interpreting the number) to “text string” sorting (sorting the letters from left to right).
    To force a “logic” sorting, you could use the TablePress Extension from https://tablepress.org/extensions/datatables-sorting-plugins/
    To make it work here, you would then have to add this to the “Custom Commands” text field on the table’s “Edit” screen:

    "columnDefs": [ { "type": "formatted-num", "targets": [ 0 ] } ]

    Regards,
    Tobias

Viewing 1 replies (of 1 total)
  • The topic ‘Wrong order after sorting’ is closed to new replies.