• Resolved longnha

    (@longnha)


    Hi,

    I have table with currency format like:

    $1
    $5
    $100
    $1,000

    The sorting is not working properly and show result like:

    $1
    $1,000
    $100
    $5

    Is that normal behavior please? Is there a way to fix it?

    Thank you.

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Yes, this is the normal behavior, because you are sorting text and not plain numbers here. To change this, I recommend to use the TablePress Extension from https://tablepress.org/extensions/datatables-sorting-plugins/

    Regards,
    Tobias

    Thread Starter longnha

    (@longnha)

    Silly me, I do have sorting extension but it’s disabled! No wonder why it’s stop working!

    Thank you very much for your response.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    no problem, you are very welcome! 🙂 Good to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

    Thread Starter longnha

    (@longnha)

    Hi,

    Sorry but I just notice that the sorting is not working for one table. The behavior is the same as before I enable the sorting the extension.

    Do you have any idea anything would cause it please?

    Thanks.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    Can you please post a link to the page with the table where this problem happens, so that I can take a direct look? Thanks!

    Regards,
    Tobias

    Thread Starter longnha

    (@longnha)

    Do you have email, or a form so I can send you the link please?

    Thanks.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    my email address is in the main plugin file “tablepress.php”.

    Regards,
    Tobias

    Thread Starter longnha

    (@longnha)

    Sent an email. Hope you can take a look on this.

    Thank you.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    thanks for the link! From what I can see, you didn’t add the necessary “Custom Command”. Just activating the Extension is not enough here.
    See https://tablepress.org/extensions/datatables-sorting-plugins/

    Regards,
    Tobias

    Thread Starter longnha

    (@longnha)

    Hi,

    Thank you for the link. I follow the instruction and it now works as expected.

    But on the table that is working, I’ve no Custom Commands for sorting, just ‘orderable’ command and it still works. So I’m kind of confused.

    Anyway, now everything work fine, so thank you. 🙂

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    yes, sometimes the auto-detection for the sorting algorithm works, but sometimes it needs the command.

    Regards,
    Tobias

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

The topic ‘Sorting not working properly’ is closed to new replies.