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

Pseudocode query:

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

---

Backlog report

Generated YYYY-MM-DD

Groups included: liberty, Librem5

Milestone One (2020-03-01)

Ticket	Title
123	Implement foo
124	Implement bar

Milestone One (2020-04-15)

Ticket	Title
125	Implement foo
126	Implement bar