View Issue Details

IDProjectCategoryView StatusLast Update
0000568Composr[All Projects] General / Uncategorisedpublic2012-06-08 19:22
ReporterChris GrahamAssigned ToChris Graham 
SeverityMinor-bug 
Status resolvedResolutionfixed 
Product Version 
Fixed in Version 
Summary0000568: Date sorting broken
DescriptionCatalogue date fields do not sort properly.

This is because the data in the database is stored as strings that aren't padded out.
e.g. "2012-2-3" (3rd February 2012) is not going to sort correctly compared to "2012-12-20". It should be stored padded like "2012-02-03".

This fix is not retroactive, but means new data will be stored correctly. Some other means to resolve existing data would have to be performed, such as writing some simple script, or editing each entry, or deleting the catalogue then reimporting using a CSV file.
TagsNo tags attached.
Time estimation (hours)
Sponsorship open

Activities

Chris Graham

2012-06-08 19:22

administrator   ~0000615

Fixed in git commit 4cca140 (https://github.com/chrisgraham/Composr/commit/4cca140 - link will become active once code pushed)

A hotfix (a TAR of files to upload) have been uploaded to this issue. These files are made to the latest intra-version state (i.e. may roll in earlier fixes too if made to the same files) - so only upload files newer than what you have already. Always take backups of files you are replacing or keep a copy of the manual installer for your version, and only apply fixes you need. These hotfixes are not necessarily reliable or well supported. Not sure how to extract TAR files to your Windows computer? Try 7-zip (http://www.7-zip.org/).

hotfix-568, 2012-06-08 8pm.tar (20,480 bytes)

Issue History

Date Modified Username Field Change
2023-02-26 18:29 Chris Graham Category General => General / Uncategorised