-- ## 11: List ufo-filter tickets ## --

-- List all open and closed tickets related to the ufo-filter component.

SELECT p.value AS __color__,
   id AS ticket, summary, version, t.type AS type, time AS created,
   (CASE status WHEN 'closed' THEN 'text-decoration: line-through;' ELSE '' END) AS __style__

  FROM ticket t

  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'

  WHERE t.component = 'ufo-filter'

  ORDER BY time DESC