Opened 6 years ago
Last modified 6 years ago
#13015 closed defect
Custom field of type time cannot be sorted — at Initial Version
Reported by: | Owned by: | ||
---|---|---|---|
Priority: | normal | Milestone: | 1.2.3 |
Component: | query system | Version: | 1.2 |
Severity: | normal | Keywords: | postgresql |
Cc: | Branch: | ||
Release Notes: | |||
API Changes: | |||
Internal Changes: |
Description
In [ticket-custom] we created a due date field for tickets:
duedate = time duedate.format = date duedate.label = Due date duedate.order = 14
Creating new tickets works and the field can be seen in custom queries, but pressing the column for sorting results in this error:
Trac detected an internal error: ProgrammingError: COALESCE types text and integer cannot be matched LINE 5: ORDER BY COALESCE("duedate".value,0)=0,"duedate".value,t.id)... ^
Note:
See TracTickets
for help on using tickets.