-- ## 1: タイプ別全チケット(解決済みチケットを含む) ## --

-- タイプ別全チケットです。

SELECT 
   (CASE status 
      WHEN 'closed' THEN 'color: #777; background: #ddd; border-color: #ccc;'
      ELSE 
        (CASE owner WHEN '$USER' THEN 'font-weight: bold' END)
    END) AS __style__,
   id AS ticket, summary,
   component,
   time AS time,
   reporter AS reporter,
   t.type  AS __group__, priority, owner AS _owner,
   changetime AS modified,
   status, 
   resolution,version AS _version
  FROM ticket t
  ORDER BY (t.type IS NULL), t.type DESC, id