Email each person their overdue Jira issues

Overdue work hides in a big board. Every Friday at 15:00 this finds the Jira issues that are past their due date and emails each person a list of their own, longest overdue first, with the due date and priority.

Issues nobody is assigned to are left out, as are people who hide their email address in Jira.

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

Overdue issuesFind issues. Save it as overdue.Jira

Overdue issues grouped by personGroup the items in overdue.issues by assignee.emailAddress and save it as overdue_by_person.

For each person in overdue_by_person:For each person in overdue_by_person:

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

Yes

Their overdue issues, one per lineWrite each item in person.items as • @item.key: @item.summary (due @item.due_date_display, @item.priority priority), one per line and save it as issue_lines.

Email the person their overdue issuesSend an email to person.key. Save it as reminder. Subject: Your overdue Jira issuesHi, These issues assigned to you are past their due date: issue_lines Please update them or move the date if plans changed.Gmail

No

No steps