単なるSQLの話なんだけど、これやりたい人が多いだろうから記録に残しておく。 予定した完了日に終わっていないチケットを一覧表示するクエリ SELECT p.value AS __color__, id AS ticket, summary, component, version, milestone, t.type AS type, c.value, (CASE STATUS WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner, time AS created, changetime AS _changetime, description AS _description, reporter AS _reporter FROM ticket t, ticket_custom c LEFT JOIN enum p