• Resolved Alaint

    (@alaint)


    Hallo,
    I am experiencing this problem with coloumn descending or ascending order.
    For example if I want to put dates in order here is what I get:

    03.03.2014
    05.03.2014
    07.01.2015
    17.01.2014
    19.06.2014
    27.03.2015

    This problem seems to involve only DATES order not the ALPHABETICAL one.
    Thank you for your attention.
    Regards

    https://wordpress.org/plugins/tablepress/

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

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    The reason for this is that your dates are in the dd.mm.yyyy format, while the DataTables JS library that TablePress uses only understands the English mm-dd-yyyy format by default.
    To change this, you could take a look at the TablePress Extension from https://tablepress.org/extensions/datatables-sorting-plugins/ which adds a sorting algorithm for your date format.

    Regards,
    Tobias

    Thread Starter Alaint

    (@alaint)

    Hallo Tobias,
    thanks for your prompt reply.
    I installed the plugin you suggested.
    The first coloumn with dates now works well, but the second one still shows problems with the descending sequence.

    Please have a look to this link
    powerize.it/test.jpg

    Thank you again.
    Regards

    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 Alaint

    (@alaint)

    Hallo Tobias, go to:

    “ferroviedellacalabria.it/fdc/bandi”

    thanks

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    thanks for the link!

    Now, I’m not exactly sure, but it might be possible that this is caused by some cells in that third column being empty. It might be possible that the DataTables JS library requires a date in all cells of that column.

    We could maybe try setting the data type of the columns manually, to see if that helps. For that, please try adding this to the “Custom Commands” textfield on the “Edit” screen of the table:

    "columnDefs": [ { "type": "date-eu", "targets": [ 1, 2 ] } ]

    Regards,
    Tobias

    Thread Starter Alaint

    (@alaint)

    Hallo Tobias
    thank you for your reply.

    I am afraid, it doesn’t seem to work.

    thanks

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    ok, I just noticed that you still seem to be using an old version of TablePress. Please update to TablePress 1.6. (You might have to update to WordPress 4.2.2 first.)

    Regards,
    Tobias

    Thread Starter Alaint

    (@alaint)

    Hallo Tobias,
    I tried to update the plugin but the version is seen as the last one. Can I manually update without loosing data?
    Any howto?

    Thanks

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    are you using WordPress 4.2.2? And which version of TablePress are you using?

    Regards,
    Tobias

    Thread Starter Alaint

    (@alaint)

    Tobias, can you give me your email? I will send you further info there.

    Thank you!

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    my email is in the main plugin file of TablePress, “tablepress.php”.

    Regards,
    Tobias

    Thread Starter Alaint

    (@alaint)

    Hallo Tobias,
    just sent mail!

    Regards

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    thanks, I just replied.

    Regards,
    Tobias

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

The topic ‘Descending – Ascending order problems’ is closed to new replies.