Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Problem: 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 

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 *

3) specify condition that your issues should match again in JQL rule like this:

project in (YOUR_PROJECT_KEY) and or duedate > now()

4) 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:  Email subject:

Code Block
titleEmail subject
linenumberstrue
#foreachYour ($issue in $issues)
   #if ($velocityCount == 1)
      Daily digest of issues in progress and past due
   #end
#endoverdue issues

6) Make sure that Send As = Separate emails

7) Add the following message templateMessage template:

Code Block
titleMessage template
linenumberstrue
Issues that have past due date <br/><br/>

<table border=1>
    <tr>
       <th>key</th>
       <th>summary</th>
       <th>assignee email</th> 
    </tr>   <th>Date Created</th>
    #foreach  ($issue in $issues)
<th>Due Date</th>
    </tr>
    #if#foreach ($issue.fields.duedate and $jirassimo.isAfter($issue.fields.duedate, $context.today))   
 in $issues)       
       <tr>
             <td>$issue.key</td>
             <td>$issue.fields.summary</td>
             <td>$!issue.fields.assignee.emailAddress <emailAddress</td>
          </tr>
       #end
    #end
</table>


<br/><br/>
Issues that are In Progress<br/><br/>
<table border=1>
    <tr>
       <th>key</th>
       <th>summary</th>
       <th>assignee email</th> 
    </tr>
    #foreach ($issue in $issues)   
       #if ($issue.fields.status.name == "In Progress" and $issue.fields.duedate and !$jirassimo.isAfter($issue.fields.duedate, $context.today))   
          <tr>
             <td>$issue.key<<td>$!issue.fields.created</td>
             <td>$issue<td>$!issue.fields.summary<duedate</td>
             <td>$!issue.fields.assignee.emailAddress </td>
          </tr>
       #end
    #end
</table>
<br>