View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005421 | Composr | core_fields | public | 2023-10-21 07:04 | 2024-07-31 22:23 |
| Reporter | Patrick Schmalstig | Assigned To | Chris Graham | ||
| Severity | Minor-bug | ||||
| Status | assigned | Resolution | open | ||
| Product Version | |||||
| Fixed in Version | |||||
| Summary | 0005421: 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 | ||||
| Time estimation (hours) | |||||
| Sponsorship open | |||||
|
|
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. |
|
|
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. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-10-21 07:04 | Patrick Schmalstig | New Issue | |
| 2023-10-21 07:05 | Patrick Schmalstig | Additional Information Updated | View Revisions |
| 2024-03-30 14:04 | Patrick Schmalstig | Tag Attached: Roadmap: v11 | |
| 2024-03-30 14:05 | Patrick Schmalstig | Tag Detached: Roadmap: v11 | |
| 2024-03-30 14:05 | Patrick Schmalstig | Tag Attached: Roadmap: Over the horizon | |
| 2024-03-30 14:05 | Patrick Schmalstig | Project | Composr alpha bug reports => Composr |
| 2024-03-30 14:28 | Patrick Schmalstig | 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-request => Minor-bug |
| 2024-07-24 21:54 | Chris Graham | Note Added: 0008911 | |
| 2024-07-31 22:23 | Patrick Schmalstig | Assigned To | => Chris Graham |
| 2024-07-31 22:23 | Patrick Schmalstig | Status | non-assigned => assigned |
| 2024-07-31 22:23 | Patrick Schmalstig | Note Added: 0009036 |
