5421: Catalogue sort ordering improvements - Composr CMS feature tracker

ID	Project	Category	View Status	Date Submitted	Last Update

5421	Composr	core_fields	public	2023-10-21 07:04	2024-07-31 22:23

Reporter	PDStig	Assigned To	Chris Graham
Priority	normal	Severity	minor
Status	assigned	Resolution	open

Summary	5421: Catalogue sort ordering improvements
Description	Catalogue field sort orders should probably be defined as a hook function. This is because some fields, such as date, are not properly sorted. I expect date fields to be sorted internally by timestamp. Instead, they are sorted according to the string value when displayed on the catalogue page.
Additional Information	It is possible this is already implemented. If so, treat this issue as a bug for the date field, and go through all field types to make sure they sort as expected.
Tags	Roadmap: v11
Attach Tags	(Separate by ",")

Time estimation (hours)
Sponsorship open

Date Added	Member	Amount Sponsored

Chris Graham 2024-07-24 21:54 administrator ~8911	This sounds like a bug. We can't sort at run-time. Always imagine there are a million records of anything - sorted in memory is not an option, we need to be able to sort via MySQL index. IIRC sometimes we do have to sort at run-time but this should be only for edge-cases where we could never hope for good performance.

PDStig 2024-07-31 22:23 administrator ~9036	Assigning to you Chris. Looks like this will be more complicated to do than expected because date and date_time fields are stored as strings. So they will be sorted as such.

View Status	Private (for security issues or disclosing of private information; if you submit as a guest, you will not be able to see your submission)
Note
Upload Files Maximum size: 32,768 KiB	Attach files by dragging & dropping, selecting or pasting them.
You are not logged in	You are not logged in. This means you will not get any e-mail notifications. And if you reply, we will not know for sure you are the original poster of the issue.

Date Modified	Username	Field	Change
2023-10-21 07:04	PDStig	New Issue
2023-10-21 07:05	PDStig	Additional Information Updated
2024-03-30 14:04	PDStig	Tag Attached: Roadmap: v11
2024-03-30 14:05	PDStig	Tag Detached: Roadmap: v11
2024-03-30 14:05	PDStig	Tag Attached: Roadmap: Over the horizon
2024-03-30 14:05	PDStig	Project	Composr alpha bug reports => Composr
2024-03-30 14:28	PDStig	Category	General / Uncategorised => core_fields
2024-07-24 21:53	Chris Graham	Tag Attached: Roadmap: v11
2024-07-24 21:53	Chris Graham	Tag Detached: Roadmap: Over the horizon
2024-07-24 21:53	Chris Graham	Severity	Feature or Request => Minor Bug
2024-07-24 21:54	Chris Graham	Note Added: 0008911
2024-07-31 22:23	PDStig	Assigned To	=> Chris Graham
2024-07-31 22:23	PDStig	Status	Not Assigned => Assigned
2024-07-31 22:23	PDStig	Note Added: 0009036