{9} All Changed Tickets

You can use this Report to see the last 40 changed tickets.

Report execution failed:
OperationalError: RIGHT and FULL OUTER JOINs are not currently supported

SELECT COUNT(*) FROM (
SELECT id AS ticket, summary, component, milestone, t.type AS type, severity, t.time AS created_,
   tc.field AS field, tc.newvalue AS description_,
   changetime AS _changetime, reporter AS _reporter
  FROM ticket t, enum p
  OUTER JOIN ticket_change tc ON tc.ticket = t.id
  WHERE p.name = t.priority AND p.type = 'priority'
AND field <> 'resolution'
AND field <> 'milestone'
AND field <> 'component'
AND (field <> 'status' AND tc.newvalue <> 'closed')
 /* GROUP BY t.id*/
  ORDER BY tc.time DESC
LIMIT 40

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