Page History
QProblem: How to write a template for a scheduled notification that will be sending out issues which are beyond their due date. The notifications should be sent to assignees of the issues and issues
A:Solution
1) Create a new Jira issues digested messaging notification configuration
2) Provide a CRON expression that specifies how often the notifications should be sent. In our case we want to send daily, so this will serve as a good start:
0 0 16 ? * MON-FRI *
32) specify condition that your issues should match again in JQL rule like this:
project in (YOUR_PROJECT_KEY) and or duedate > now()
34) add the following Group By:
fields.assignee.emailAddress
This will ensure that issues will be grouped by assignees.
Specify the report recipients by choosing Assignee in combo-box "To". The issues retrieved in step 3 will be grouped by value chosen in step 4, so you don't have to worry about how to send the right issues to the right people.
5) Specify subject of your email: 4) Assign remaining notification fields as following:
| Code Block | ||||
|---|---|---|---|---|
| ||||
#foreachYour ($issue in $issues) $!issue.fields.assignee.emailAddress #end | ||||
| Code Block | ||||
| ||||
overdue issues
|
6) Make sure that Send As = Separate emails
7) Add the following message template
| Code Block | ||||
|---|---|---|---|---|
| ||||
Issues that have past due date <br/><br/>
<table border=1>
<tr>
<th>key</th>
<th>summary</th>
<th>assignee email</th>
<th>Date Created</th>
<th>Due Date</th>
</tr>
#foreach ($issue in $issues)
#if ($issue.fields.duedate and $jirassimo.isAfter($context.today, $issue.fields.duedate))
<tr>
<td>$issue.key</td>
<td>$issue.fields.summary</td>
<td>$!issue.fields.assignee.emailAddress</td>
<td>$!issue.fields.created</td>
<td>$!issue.fields.duedate</td>
</tr>
#end
#end
</table>
<br>
<br>
Issues that are In Progress but have not reached their due date yet<br/><br/>
<table border=1>
<tr>
<th>key</th>
<th>summary</th>
<th>assignee email</th>
<th>Date Created</th>
<th>Due Date</th>
<th>Status</th>
</tr>
#foreach ($issue in $issues)
#if ($issue.fields.status.name == "In Progress" and $issue.fields.duedate and !$jirassimo.isAfter($context.today, $issue.fields.duedate))
<tr>
<td>$issue.key</td>
<td>$issue.fields.summary</td>
<td>$!issue.fields.assignee.emailAddress</td>
<td>$!issue.fields.created</td>
<td>$!issue.fields.duedate</td>
<td>$issue.fields.status.name</td>
</tr>
#end
#end
</table> |
