id summary reporter owner description type status milestone component version severity resolution keywords cc 1052 Add ticket report that shows ticket without milestones Marcus Lindblom "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 }}}" Patches closed To Be Determined None Cosmetic wontfix