-- ## 4: 着手中の未解決チケット (担当者別) ## --

-- 
-- 担当者別に優先度順に並べた、着手中の未解決チケットの一覧です。


SELECT p.value AS __color__,
   owner AS __group__,
   id AS ticket, summary AS 概要, component AS コンポーネント,
   milestone AS マイルストーン, t.type AS 分類, time AS 登録日付,
   changetime AS _更新日付, description AS _説明,
   reporter AS _報告者
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE status = 'accepted'
  ORDER BY owner, CAST(p.value AS int), t.type, time