close Warning: Can't synchronize with repository "(default)" (/var/svn/mms does not appear to be a Subversion repository.). Look in the Trac log for more information.

{10} All Tickets by Changes

Report execution failed: 
DataError: timestamp out of range: "1.26528e+15"

SELECT * FROM (
  SELECT p.value AS __color__, 
    to_char(to_TIMESTAMP (changetime), 'YYYY/MM') AS __group__,
    (CASE status WHEN 'closed' 
      THEN 'color: #777; background: #ddd; border-color: #ccc;'
      ELSE (CASE owner WHEN %s THEN 'font-weight: bold' END)
      END) AS __style__,
    id AS ticket, summary, component, milestone, t.type AS type, 
    reporter, owner AS _owner,
    time AS created, changetime AS modified, description AS _description
  FROM ticket t LEFT JOIN enum p 
  ON p.name = t.priority AND p.type = 'priority'
  WHERE (t.resolution <> 'invalid' OR t.resolution IS NULL)
  ORDER BY modified DESC, created DESC
) AS tab LIMIT 1
Note: See TracReports for help on using and creating reports.