{53} Test
Report execution failed:
InternalError: (1054, u"Unknown column 'time.now' in 'field list'")
SELECT COUNT(*) FROM (
SELECT p.value AS __color__,
t.type,
id AS ticket, summary, component, version, t.severity AS severity,
owner, status,
(SELECT (CASE
WHEN delta > 86400 THEN round(delta/86400.0) || ' days'
WHEN delta > 3600 THEN round(delta/3600.0) || ' hours'
ELSE round(delta/60) || ' mins'
END)
FROM (SELECT ((time.now * 1000000 - changetime) / 1000000.0) AS delta
) AS ct
) AS LastModified,
COALESCE(tc.change_cnt || ' by ' || tc.author_cnt, '-') as Chgs_Auths,
description AS _description,
reporter AS _reporter,
milestone AS _milestone
FROM ticket t LEFT JOIN
(SELECT ticket, count(distinct author) as author_cnt,
count(*) as change_cnt
FROM ticket_change
WHERE field = 'comment' GROUP BY ticket) tc ON (t.id = tc.ticket),
enum p,
(SELECT unix_timestamp(now())) time
WHERE t.status != 'closed'
AND (t.keywords IS NULL OR t.keywords NOT LIKE '%needinfo%')
AND p.name = t.priority AND p.type = 'priority'
AND t.milestone = '0.12'
ORDER BY changetime desc, p.value, t.severity, time
) AS tab
Note:
See TracReports
for help on using and creating reports.

