Comments Jim Hartwell started the conversationApril 1, 2024 at 9:57amThe column/Data: 'Time' attribute doesn't handle ascending sorting correctly, '09:30:00 AM' sorts after '10:00:00 AM'. 1,846Miloš repliedApril 2, 2024 at 2:51amHi Jim, If you wish to sort a String Column type as 'time logic', that is not possible. The String Column can only sort as alphabetical logic. If you wish it to sort by 'time', then you have to change this to a "Time Column" data type and then it will start sorting as time logic. Since version 6.2, we now have the 'seconds' included in the Time columns. Let me know if that helps. Thank you.Kind Regards, Miloš Jovanović[email protected] Rate my supportTry our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/ wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community You can try wpDataTables add-ons before purchasing on these sandbox sites: Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables Sign in to reply ...
The column/Data: 'Time' attribute doesn't handle ascending sorting correctly, '09:30:00 AM' sorts after '10:00:00 AM'.
Hi Jim,
If you wish to sort a String Column type as 'time logic', that is not possible.
The String Column can only sort as alphabetical logic.
If you wish it to sort by 'time', then you have to change this to a "Time Column" data type and then it will start sorting as time logic.
Since version 6.2, we now have the 'seconds' included in the Time columns.
Let me know if that helps.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables