Skip to content

Instantly share code, notes, and snippets.

@wtnabe
Forked from anonymous/gist:4266147
Created December 12, 2012 08:45
Show Gist options
  • Save wtnabe/4266171 to your computer and use it in GitHub Desktop.
Save wtnabe/4266171 to your computer and use it in GitHub Desktop.
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