{14} Tickets closed in the last week (or so) (dates in UTC)

Show all tickets closed in the last week (or so)

Report execution failed:
InternalError: (1305, u'FUNCTION trac.STRFTIME does not exist')

SELECT COUNT(*) FROM (
  SELECT p.value                AS __color__,
         'Closed '||STRFTIME('%m-%d', c.time/1000000, 'unixepoch') AS __group__,
         (CASE t.status WHEN 'assigned' THEN 'font-size: 18pt !important; font-weight: bold !important;' ELSE '' END) AS __style__,
         c.author               AS "closed by",
         milestone              AS "when",
         resolution,
         id                     AS ticket,
         (CASE t.status WHEN 'assigned' THEN '* ' ELSE '' END) || summary AS summary,
         keywords,
         component,
         t.type  AS type,
         severity,
         STRFTIME("%Y-%m-%d", t.time/1000000, "unixepoch") AS opened,
         ROUND((c.time-t.time)/1000000/(60*60*24))||' days' AS age
    FROM ticket t, enum p, ticket_change c
   WHERE t.id=c.ticket
         AND c.field LIKE "status%"     -- wtf, a straignt ="status" match fails!?
         AND c.newvalue="closed"
         AND (strftime('%s', 'now') - c.time/1000000) <= (60 * 60 * 24 * 8)
         AND p.name = t.priority 
         AND p.type = 'priority'
GROUP BY t.id
ORDER BY STRFTIME('%Y-%m-%d', c.time/100000, 'unixepoch') DESC,
         c.author,
         t.id

) AS tab
Note: See TracReports for help on using and creating reports.