Changes between Version 11 and Version 12 of khc

Timestamp:

Apr 12, 2007, 5:18:19 AM (17 years ago)

Author:

khc

Comment:

--

khc

@@ -7 +7 @@
 [http://developer.pidgin.im/query?status=new&status=assigned&status=reopened&type=enhancement&order=changetime&desc=1 Enhancements]
 
-SELECT id as ticket, created, status, summary FROM ticket 
+-- ## 1: Active Tickets ## --
 
-[[TicketQuery(version=1.0|2.0)]]
+-- 
+--  * List all active tickets by priority.
+--  * Color each row based on priority.
+--  * If a ticket has been accepted, a '*' is appended after the owner's name
+
+
+SELECT p.value AS __color__,
+   id AS ticket, summary, component, version, milestone, t.type AS type, 
+   (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, enum p
+  WHERE status IN ('new', 'assigned', 'reopened') 
+AND p.name = t.priority AND p.type = 'priority'
+  ORDER BY p.value, milestone, t.type, time