Iterate through Releases and send a scheduled email

Robert Newton_snqjti

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

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.