bosun report status --project=one,two

User story: I am a project manager. I want a simple report of ticket status across the whole project.

Proposed solution: A report named "status" that accepts one parameter, a list of groups.

bosun report contributor --project=liberty,Librem5

Pseudocode query:

SELECT *
FROM issues
AND project IN (liberty, Librem5)
AND milestone is open
GROUP BY status
ORDER BY status, milestone, due date, user, ticket number

Sample output (see below):

• Assume tickets are valid (no linting in this report)
• If a ticket is assigned to multiple statuses, show it in each one
• "In progress" subsection layout is unique
• All other subsections use the same layout
• Missing values (e.g. due date) should just report "None"

Status report

Generated YYYY-MM-DD

Groups included: liberty, Librem5

In progress

Ticket	Title	Milestone	Due date	Contributor
123	Implement foo	First	2020-13-13	ada.lovelace
124	Implement bar	Second	2020-13-14	blaise.pascal

Ready

Milestone first (2020-13-13)

Ticket	Title	Contributor
125	Refactor foo	ada.lovelace
126	GUI for bar	ada.lovelace
127	GUI for noo	blaise.pascal

Milestone second (2020-13-14)

Ticket	Title	Contributor
127	Implement foo in C	ada.lovelace
128	Highlight bar	blaise.pascal

Waiting for review

Milestone first (2020-13-13)

Ticket	Title	Contributor
125	Refactor foo	ada.lovelace
126	GUI for bar	blaise.pascal

Milestone second (2020-13-14)

Ticket	Title	Contributor
127	Implement foo in C	ada.lovelace
128	Highlight bar	blaise.pascal

On hold

Milestone first (2020-13-13)

Ticket	Title	Contributor
129	Refactor foo	ada.lovelace
130	GUI for bar	blaise.pascal

Milestone second (2020-13-14)

Ticket	Title	Contributor
131	Implement foo in C	ada.lovelace
132	Highlight bar	blaise.pascal

Closed

Milestone first (2020-13-13)

Ticket	Title	Contributor
133	Refactor foo	ada.lovelace
134	GUI for bar	blaise.pascal

Milestone second (2020-13-14)

Ticket	Title	Contributor
135	Implement foo in C	ada.lovelace
136	Highlight bar	blaise.pascal