{19} Expired infoneeded tickets

tickets which need more information but haven't been updated in 30 days

Report execution failed:
ProgrammingError: (1064, u"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= 'infoneeded' OR t.status == 'infoneeded_new')\r\n         AND p.name = t.priorit' at line 17")

SELECT COUNT(*) FROM (
  SELECT p.value                AS __color__,
         'Last Modified '||STRFTIME('%m-%d', t.changetime/1000000, 'unixepoch') AS __group__,
         (CASE t.status WHEN 'assigned' THEN 'font-size: 18pt !important; font-weight: bold !important;' ELSE '' END) AS __style__,
         id                     AS ticket,
         owner,
         milestone              AS "when",
         status,
         summary,
         keywords,
         version,
         component,
         SUBSTR(t.type, 0, 1)   AS type,
         severity
    FROM ticket t, enum p
   WHERE (STRFTIME('%s', 'now') - (t.changetime/1000000)) >= (60 * 60 * 24 * 30)
         AND (t.status == 'infoneeded' OR t.status == 'infoneeded_new')
         AND p.name = t.priority 
         AND p.type = 'priority'
GROUP BY t.id
ORDER BY STRFTIME('%m-%d', t.changetime/1000000, 'unixepoch'),
         t.id
) AS tab
Note: See TracReports for help on using and creating reports.