Changes between Version 12 and Version 13 of khc

Timestamp:

Apr 12, 2007, 5:25:32 AM (17 years ago)

Author:

khc

Comment:

--

khc

@@ -6 +6 @@
 
 [http://developer.pidgin.im/query?status=new&status=assigned&status=reopened&type=enhancement&order=changetime&desc=1 Enhancements]
-
--- ## 1: Active Tickets ## --
-
--- 
---  * 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