[Plugin: WP-Table Reloaded] Sorting tables by time uses wrong time zone in California

  • Resolved pndsWeb

    (@pndsweb)


    12 years, 1 month ago

    Previously posted here without response: <a href=”http://code.google.com/p/wp-table-reloaded/issues/detail?id=87
    “>http://code.google.com/p/wp-table-reloaded/issues/detail?id=87

    Issue 87: Sorting tables by time results in anything earlier than 10:00 AM to be listed at end of table, not beginning

    What steps will reproduce the problem?
    1. Go to this website: http://www.ncwsa.org/meeting-map-list.
    2. Click the column heading “Time” to do an ascending sort.
    3. The first row is time: “10:00 AM”.
    4. Click the right arrow key 9 times to advance to the end of the table (almost 1,000 entries).
    4. The last two rows are time: “9:45 AM”.
    5. The one before that is: “9:30 AM”, etc.

    What is the expected output? What do you see instead?
    I expect to see time “8:30 AM” to be the first row of the table, not “10:00 AM”.

    What version of the plugin, WordPress and PHP are you using?
    (Please provide the “Debug Information” from the bottom of the “About the
    plugin” screen here.)
    Plugin:
    You are using the following versions of the software. Please provide this information in bug reports.

    · WP-Table Reloaded (DB): 1.9.3
    · WP-Table Reloaded (Script): 1.9.3
    · Plugin installed: 2012/01/30 15:44:46
    · WordPress: 3.3.1
    · PHP: 5.3.3
    · mySQL (Server): 5.0.92-community
    · mySQL (Client): 5.0.92

    What browser do you use on which operating system?
    Occurs on all browser sI have installed on both a PC and a Mac: IE 7.0 and 8.0 (PC only, Windows XP Home Edition), Safari 5.1.2, Firefox 10.0.2, Chrome 17.0.963.56 and Opera 11.60 build 1185 on a Mac OSX 10.6.8.

    If you can make screenshots that show the problem, please attach them.
    Please also add an URL to the page with the problem, if possible.
    http://ncwsa.org/meeting-map-list

    Please provide any additional information below.

    Remember to check back on this issue after while to see further questions
    and instructions, (or hopefully a positive answer).
    Thank you for reporting the bug!

    See screenshot at the URL listed above.

    http://wordpress.org/extend/plugins/wp-table-reloaded/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    12 years, 1 month ago

    Hi,

    thanks for your post – and sorry for not answering the issue post on Google Code yet… I somehow forgot about it, while I was sick last week…

    This issue basically happens, because the integrated DataTables JavaScript library (which does the sorting) can not sort dates or time automatically, as these are obviously sorted differently than numbers or strings.
    As it seems, there no “plugin” for time sorting available for the DataTables library yet (see http://datatables.net/plug-ins/sorting), so it would need to be developed first (something which I can not do, unfortunately).
    So, until this exists, I don’t see a possibility to integrate time sorting 🙁

    Regards,
    Tobias

    Thread Starter pndsWeb

    (@pndsweb)

    12 years, 1 month ago

    Hi Tobias,

    Thank you so much for your rapid response. Love your plugin and your continued dedicated support!

    Sorry to hear you were sick. Right after I posted this, I noticed your rapid responses to other issues with the same message about your illness.

    I’ll take a look at the DataTables library and see what I can do.

    Thanks again,
    Errol

    Plugin Author TobiasBg

    (@tobiasbg)

    12 years, 1 month ago

    Hi Errol,

    thanks for the kind words, I appreciate it.

    Yes, investigating if and how the DataTables library supports time sorting is the best option for now.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Plugin: WP-Table Reloaded] Sorting tables by time uses wrong time zone in California’ is closed to new replies.