Skip to content

Instantly share code, notes, and snippets.

Created December 12, 2012 08:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save anonymous/4266147 to your computer and use it in GitHub Desktop.
Save anonymous/4266147 to your computer and use it in GitHub Desktop.
Tracで期限付きで閉じてないmilestoneだけリストアップするreport
SELECT p.value AS __color__,
milestone||' Release' AS __group__,
id AS ticket, summary, component, version, t.type AS type,
owner, status,
time AS created,
changetime AS _changetime, t.description AS _description,
reporter AS _reporter
FROM ticket t, enum p
join milestone m on (t.milestone = m.name)
WHERE m.due > 0 and m.completed == 0 and t.status != 'closed'
AND p.name = t.priority AND p.type = 'priority'
ORDER BY m.due, p.value, time
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment