Email each person their open Jira bugs on Fridays

A bug nobody is reminded of tends to sit. Every Friday afternoon this looks up the bugs in Jira that are not done yet and emails each person a list of their own, with how many days each has been open and a link to it.

Bugs with nobody assigned are left out, and so is anyone who hides their email address in their Jira profile, because there is no one to send it to.

Run every Friday at 15:00.Run every Friday at 15:00.

Open bugsFind issues matching 'issuetype = Bug AND statusCategory != Done AND assignee is not EMPTY ORDER BY assignee'. Save it as bugs.Jira

Bugs grouped by personGroup the items in bugs.issues by assignee.emailAddress and save it as bugs_by_person.

Email each personFor each person in bugs_by_person:

If person.key isn't blankIf person.key isn't blank

Yes

Their bugsWrite each item in person.items as • @item.key: @item.summary (open @item.days_open days) @item.url, one per line and save it as bug_lines.

Email the bug listSend an email to person.key. Save it as email_sent. Subject: Your open bugsYou have person.count open bugs: bug_linesGmail

No

No steps