Boost C++ Libraries: Ticket #1052: Add ticket report that shows ticket without milestones https://svn.boost.org/trac10/ticket/1052 <p> 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. </p> <pre class="wiki">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 </pre> en-us Boost C++ Libraries /htdocs/site/boost.png https://svn.boost.org/trac10/ticket/1052 Trac 1.4.3 Douglas Gregor Fri, 15 Jun 2007 14:20:09 GMT <link>https://svn.boost.org/trac10/ticket/1052#comment:1 </link> <guid isPermaLink="false">https://svn.boost.org/trac10/ticket/1052#comment:1</guid> <description> <p> Why isn't the "Active Tickets by Milestone" report good enough? Just scroll down to get the same information. </p> </description> <category>Ticket</category> </item> <item> <author>Marcus Lindblom <macke@…></author> <pubDate>Mon, 18 Jun 2007 08:46:14 GMT</pubDate> <title/> <link>https://svn.boost.org/trac10/ticket/1052#comment:2 </link> <guid isPermaLink="false">https://svn.boost.org/trac10/ticket/1052#comment:2</guid> <description> <p> It actually is, I think. </p> <p> We use our view to quickly verify that there are no non-assigned tickets, but I suppose that's mostly a matter of taste. ;) </p> </description> <category>Ticket</category> </item> <item> <dc:creator>Douglas Gregor</dc:creator> <pubDate>Mon, 18 Jun 2007 10:52:19 GMT</pubDate> <title>status changed; resolution set https://svn.boost.org/trac10/ticket/1052#comment:3 https://svn.boost.org/trac10/ticket/1052#comment:3 <ul> <li><strong>status</strong> <span class="trac-field-old">new</span> → <span class="trac-field-new">closed</span> </li> <li><strong>resolution</strong> → <span class="trac-field-new">wontfix</span> </li> </ul> Ticket