-- ## 24: Testing Tickets ## --

-- This report lists tickets that have fixes/patches posted, but need testing to verify that the problem is fixed.
-- 
-- It shows any non-closed tickets that have "testing" in the Keyword field.
-- Since some tickets have the "testing" keyword for other reasons, this report may list false positives.
-- 
-- The tickets are color-coded by Type, and ordered by Type and Id.
-- 
-- Original discussion: http://irclog.perlgeek.de/parrotsketch/2010-08-03#i_2660866

SELECT    Id          AS ticket,
          Summary,
          Component,
          Priority,
          Version,
          Milestone,
          Type,
          (   -- This is the ordered type, taken from the lookup table.
              -- i.e. bug, cage, todo, patch, RFC, feature, spam, roadmap
              SELECT value
              FROM   enum
              WHERE  enum.type = 'ticket_type'
              AND    enum.name = ticket.type
          )           AS __color__,
          Owner,
          Status,
          Time        AS created,
          Changetime  AS _changetime,
          Description AS _description,
          Reporter    AS _reporter
FROM      ticket
WHERE     status <> 'closed' 
  AND     Keywords ILIKE '%testing%'
ORDER BY  __color__, Id DESC