Iterate through Releases and send a scheduled email

[Robert Newton]

Looking for help in a task to create a scheduled automation that iterates through each of the unreleased releases/versions, queries for the stories associated with each release, and then sends out a separate email for each release.

The trouble I'm running into is that there doesn't seem to be a way to iterate through releases in automation. The following JQL can be run to grab all of the stories

fixVersion in unreleasedVersions() and project = MyProject

But how does one grab the unique fixVersions from all the stories gathered here?

[Darryl Lee · Accepted solution]

Hey @Robert Newton - yeah I think the problem is that JQL only is capable of returning issues. So you may have to go to the Jira REST API. 

There's details on how to do this here:

• Automation for Jira - Send web request using Jira REST API 

And then you could hit this endpoint to get all the versions:

• Get project versions 

And (assuming you're on Cloud), you can then iterate through all of the versions using Advanced Branching.

So you should be able to iterate through {{webResponse.body}} for each {{eachVersion.id}} and do a Lookup Issues for each version and generate a notification.

Well, in theory. Give it a spin, let us know if you run into any issues.

[Robert Newton]

@Darryl LeeThanks Darryl, this was exactly what I needed. I wasn't aware that the API existed to pull information like releases.

[Darryl Lee]

Ah yeah, it's a bit tricky, but Releases are tied to Versions, so hopefully that API has what you're looking for.

https://support.atlassian.com/jira-software-cloud/docs/enable-releases-and-versions/