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.

Sprint in opensprints() AND issuetype = Story AND Resolution is empty
  • Add the Create variable action with the parameters below:

    • Variable name: OpenedIssues

    • Smart Variable:

{{#lookupIssues}}<tr><td><a href="{{url}}">{{key}}</a></td><td><a href="{{url}}">{{summary}}</a></td><td><em>{{assignee.displayName}}</em></td></tr>{{/}}
  • 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.

Sprint in opensprints() AND issuetype = Story AND Resolution is not empty
  • Add the Create variable action with the parameters below:

    • Variable name: ResolvedIssues

    • Smart Variable:

{{#lookupIssues}}<tr><td><a href="{{url}}">{{key}}</a></td><td><a href="{{url}}">{{summary}}</a></td><td><em>{{assignee.displayName}}</em></td></tr>{{/}}
  • Add the Send email action with the settings below:

In More Options, untick the option Convert line breaks to HTML line breaks

Send as HTML
  • To: Choose the Jira group of your choice

  • Subject: You can use the suggestion below:

List of on-going and resolved issues in current sprint
  • 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:

Automation rule sending out list of open and closed stories in a sprint

Example of email sent by this rule

Example of email being sent out by automation rule

Updated on May 31, 2024

Still need help?

The Atlassian Community is here for you.