{9} to dos
Report execution failed:
ProgrammingError: syntax error at or near "'percent completed'" LINE 9: ...EN d.value = '0' THEN 'None' ELSE d.value END) AS 'percent c... ^
SELECT COUNT(*) FROM ( SELECT p.value AS __color__, id AS ticket, summary, status,component, milestone, priority, owner, status, time AS created, changetime AS _changetime, description AS _description, reporter AS _reporter, (CASE WHEN c.value = '0' THEN 'None' ELSE c.value END) AS closing, (CASE WHEN d.value = '0' THEN 'None' ELSE d.value END) AS 'percent completed' FROM ticket t LEFT OUTER JOIN ticket_custom c ON (t.id = c.ticket AND c.name = 'due_close') LEFT OUTER JOIN ticket_custom d ON (t.id = d.ticket AND d.name = 'percent_completed') JOIN enum p ON p.name = t.priority AND p.type='priority' WHERE status <> 'closed' ORDER BY p.value, milestone, severity, time ) AS tab
Note:
See TracReports for help on using and creating reports.