Versions Compared

Key

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

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

1) Create a new Custom scheduled notification

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.

  4) Assign remaining notification fields as following:

Code Block
titleEmail Address
linenumberstrue
#foreach ($issue in $issues)
   $!issue.fields.assignee.emailAddress
#end
Code Block
titleEmail subject
linenumberstrue
#foreach ($issue in $issues)
   #if ($velocityCount == 1)
      Daily digest of issues In progress, To Do and In Review with past due
   #end
#endYour overdue issues
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> 
       <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>

On line 12, we're making sure that issue we're working on has duedate assigned and it is after today. Issues that satisfy this criteria are considered to be missing their due date.

...