-- ## 10: List ufo-core tickets ## --

-- List all open and closed tickets related to the ufo-core 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 
        (CASE owner WHEN $USER THEN 'font-weight: bold' END)
    END) AS __style__

  FROM ticket t

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

  WHERE t.component = 'ufo-core'

  ORDER BY time DESC