feature request / bug tracker
|Anonymous | Login | Signup for a new account||2013-05-18 06:40 EDT|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0000568||ocPortal||[All Projects] General||public||2012-06-08 15:22||2012-06-08 15:22|
|Assigned To||Chris Graham|
|Target Version||Fixed in Version|
|Summary||0000568: Date sorting broken|
|Description||Catalogue 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.
|Tags||No tags attached.|
|Time estimation (hours)|
|Attached Files||hotfix-568, 2012-06-08 8pm.tar [^] (20,480 bytes) 2012-06-08 15:22|
Chris Graham (administrator)
Fixed in git commit 4cca140 (https://github.com/chrisgraham/ocPortal/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/ [^]).
|Copyright © 2000 - 2010 MantisBT Group|