{32} Tickets created in the last week (or so) (dates in UTC) (backup copy)

Show all active tickets created in the last week

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

SELECT COUNT(*) FROM (
  SELECT p.value                AS __color__,
         'Opened '||STRFTIME('%m-%d', t.time/1000000, 'unixepoch') AS __group__,
         (CASE t.status WHEN 'assigned' THEN 'font-weight: bold !important;' ELSE '' END) AS __style__,
         id                     AS ticket,
         owner,
         milestone              AS "when",
         status,
         summary,
         keywords,
         version,
         component,
         t.type   AS type,
         severity
    FROM ticket t, enum p
   WHERE (STRFTIME('%s', 'now') - t.time/1000000) <= (60 * 60 * 24 * 8)
         AND t.status <> 'closed'
         AND p.name = t.priority 
         AND p.type = 'priority'
GROUP BY t.id
ORDER BY STRFTIME('%Y-%m-%d', t.time/1000000, 'unixepoch') DESC,
         t.id

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