Automation For Jira - How to create a rule that sends list of opened and closed stories from an on-going Sprint
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
This article describes how to create an Automation Rule using the Lookup Issues action (available in Automation for Jira from the version 9.0.1), which will send a daily email to a group of users, including the list of opened and closed stories from on-going sprints.
Note that this solution is only valid in the case where parallel Sprints are disabled in Jira (there is only one on-going Sprint per backlog).
Solution
Rule configuration details
The rule will need to be configured as follows:
Add the Scheduled trigger with the settings below:
Frequency: Once per day
Select the option simply run the conditions and actions without providing issues
Add the Lookup issues action with the JQL below. Feel free to adjust it to your liking, for example by filtering with a specific project.
|
Add the Create variable action with the parameters below:
Variable name: OpenedIssues
Smart Variable:
|
Add the Lookup issues action with the JQL below. Feel free to adjust it to your liking, for example by filtering with a specific project.
|
Add the Create variable action with the parameters below:
Variable name: ResolvedIssues
Smart Variable:
|
Add the Send email action with the settings below:
In More Options, untick the option Convert line breaks to HTML line breaks
To: Choose the Jira group of your choice
Subject: You can use the suggestion below:
|
Content: You can use the suggestion below, which will list all the issues along with their URL, summary, and assignee:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
<h2>List of on-going and resolved issues in current sprint</h2>
<h3>On-going Issues from Sprint</h3>
<table border="0" cellspacing="0" cellpadding="2">
<thead>
<tr>
<th align= "left">Key</th>
<th align= "left">Summary</th>
<th align= "left">Assignee</th>
</tr>
</thead>
<tbody>
{{OpenedIssues}}
</tbody>
</table>
<h3>Resolved Issues from Sprint</h3>
<table border="0" cellspacing="0" cellpadding="2">
<thead>
<tr>
<th align= "left">Key</th>
<th align= "left">Summary</th>
<th align= "left">Assignee</th>
</tr>
</thead>
<tbody>
{{ResolvedIssues}}
</tbody>
</table>Screenshot of the rule
The complete rule is illustrated in the screenshot below:
Example of email sent by this rule
Was this helpful?