{7} Open Tickets Assigned to Me

  • List active tickets by priority.
  • Show all tickets owned by the logged-in user in a group first.
  • Color of row based on priority
Report execution failed:
OperationalError: (1060, "Duplicate column name 'summary'")

SELECT COUNT(*) FROM (
SELECT p.value AS __color__,
  id AS ticket, summary, version, component, milestone, t.type AS type,
  status, reporter, time AS created, changetime AS modified, summary, keywords
FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
WHERE ((status is null) or (status <> 'closed'))
  AND lower(owner) = lower(%s)
ORDER BY p.value, version, component, id
) AS tab
Note: See TracReports for help on using and creating reports.