[Boost-bugs] [Boost C++ Libraries] #1052: Add ticket report that shows ticket without milestones

Subject: [Boost-bugs] [Boost C++ Libraries] #1052: Add ticket report that shows ticket without milestones
From: Boost C++ Libraries (noreply_at_[hidden])
Date: 2007-06-15 13:58:06

#1052: Add ticket report that shows ticket without milestones
--------------------------------------------+-------------------------------
 Reporter:  Marcus Lindblom <macke_at_[hidden]>  |        Type:  Patches         
   Status:  new                             |   Milestone:  To Be Determined
Component:  None                            |     Version:                  
 Severity:  Cosmetic                        |    Keywords:                  
--------------------------------------------+-------------------------------
 There are quite a few tickets without milestones. This report is what we
 use to detect those. Having a milestone always makes for a better roadmap.

 {{{
 SELECT p.value AS __color__,
    id AS ticket, summary, component, version, 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
       milestone = '' AND
       p.name = t.priority AND
       p.type = 'priority'
   ORDER BY p.value, t.type, time
 }}}

-- 
Ticket URL: <http://svn.boost.org/trac/boost/ticket/1052>
Boost C++ Libraries <http://www.boost.org/>
Boost provides free peer-reviewed portable C++ source libraries.