Sorting Issue

  • Resolved cirruslab

    (@cirruslab)


    5 years, 3 months ago

    So I have a hidden Column 2 to that has dates like: 11/08/2019.

    and custom command:
    "columnDefs": [ { "orderData": [ 1 ], "targets": [ 2 ] }, { "visible": false, "targets": [ 1 ] } ]

    In the backend it is sorting them properly, but in public when I want to sort that column, it seems to be ignoring the year.

    The page I need help with: [log in to see the link]

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

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    Can you please try extending that to

    "columnDefs": [ { "orderData": [ 1 ], "targets": [ 2 ] }, { "visible": false, "type": "date", "targets": [ 1 ] } ]

    If that doesn’t work, we might have to switch to a YYYY-MM-DD date format for the hidden column, as that can be sorted as text.

    Regards,
    Tobias

    Thread Starter cirruslab

    (@cirruslab)

    Awesome, thanks.

    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!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Sorting Issue’ is closed to new replies.