How can I create a custom email notification to list out unreleased fix version issues by version?

[Patrick]

Hello there!

We are looking to create a custom notification using the automation tool in Jira. The trigger can be scheduled and the action will be an email notification, this is the easy part.

What I'm wondering is if there is a creative way to list out all the issues that are in unreleased versions, organized by version?

I know we can use the lookup issues action to find all the issues in unreleased versions, but how can I organize them in an email notification so that they are in a list by each version. We would look for something like below:

Version 1

• issue key 1
• issue key 2
• etc

Version 2

• issue key 3
• issue key 4
• etc

I'm thinking something with a Lookup Table could help, but not really sure. Ideally this would be as automated as possible, but if we need to add new versions to the rule as they come up, that would also be acceptable.

Thanks in advance for any answers!

[Bill Sheboy]

Hi @Patrick 

If you have an unknown number of versions to report upon, the format you describe may not be possible with an automation rule.  Some reasons are you cannot nest branches, and even if you could, there is no temporary storage (like created variables or tables) that persist outside of a branch, and finally that you cannot yet dynamically update lookup tables.

You could get close to your format using a lookup issues action with JQL to gather the issues, sorted on the fix version, and then produce an output table showing the fix version, issue, etc. in that order.

Kind regards,
Bill

[Patrick]

Thanks @Bill Sheboy , that was my thought as well. 

I was also thinking it might be possible with the API, but this is beyond my level of expertise.

[Bill Sheboy]

I do not believe that is possible with the out-of-the-box REST API functions either. 

If you have access to some engineers on your team, they could probably write a function to do this in other code, and host that as a function for your rule to call.  At that point...you might as well have the external function send the report email :^)

[Ollie Guan]

Hi @Patrick ,

Automation is a good option, but if you just need to trigger this email on a regular basis, using the subscription feature can also suit your needs.

https://support.atlassian.com/jira-software-cloud/docs/manage-filters/

[Patrick]

We thought about that, but we'd like all the issues in one email in the format I specified above, from what I know filter subscriptions can't be formatted.