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.
{3} Active Tickets by Milestone
This report shows how to color results by priority,
while grouping results by milestone.
Last modification time, description and reporter are included as hidden fields
for useful RSS export.
Report execution failed:
OperationalError: database is locked
SELECT p.value AS __color__,
milestone||' Release' AS __group__,
id AS ticket, summary, component, version, t.type AS type,
owner, status,
time AS created,
changetime AS _changetime, description AS _description,
reporter AS _reporter
FROM ticket t
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
WHERE status <> 'closed'
ORDER BY __group__ ASC, `summary` DESC, (milestone IS NULL),milestone, p.value, t.type, time
LIMIT 100 OFFSET 1100
Note:
See
TracReports for help on using and creating reports.