bosun report backlog
User story: I am a project manager. I want a simple report of triaged tickets that have not been assigned.
Proposed solution: A report named "backlog" that accepts one parameter, a list of groups.
bosun report backlog --group=liberty,Librem5
SELECT * FROM issues WHERE project IN (liberty, Librem5) AND issue is open AND milestone IS NOT NULL AND assigned IS NULL GROUP BY milestone ORDER BY milestone due date, project name, creation datetime descending
Sample output (see below):
- Assume tickets are valid (no linting in this report)
- For example, if they already have a due date they should still appear, no logic is needed to detect or exclude this
Groups included: liberty, Librem5
Milestone One (2020-03-01)
Milestone One (2020-04-15)