close
Hint: if the report failed due to automatic modification of the ORDER BY clause or the addition of LIMIT/OFFSET, please look up @SORT_COLUMN@ and @LIMIT_OFFSET@ in TracReports to see how to gain complete control over report rewriting.
{9} All Tickets & Status
- List all active tickets by priority.
- Color each row based on priority.
- If a ticket has been accepted, a '*' is appended after the owner's name
Report execution failed:
ProgrammingError: ORDER BY "status" is ambiguous
LINE 9: ORDER BY "status" ASC, p.value, t.type, time
^
SELECT p.value AS __color__,
id AS ticket, summary, component, status, t.type AS type,
t.owner, t.status,
t.time AS created,
t.changetime AS _changetime, t.description AS _description,
reporter AS _reporter
FROM ticket t
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
ORDER BY "status" ASC, p.value, t.type, time
LIMIT 100 OFFSET 0
Note:
See
TracReports
for help on using and creating reports.