Automation - how to find the active Sprint name that corresponds to one of our boards

[Claudio Rouillon]

Hi Jira Community - 

I need to setup an automation to create a weekly release based on the name of the Active Sprint. (In the past I created releases with names based on the date the autom, ran).

However our project has 2 diff boards and 2 diff sprint names conventions, I am interested in getting the Sprint Name from one board. I can set the Board ID in a Lookup Table step in my automation.

So the question really is, how to pull the Sprint Name associated to a given board id.

Thanks.

[Claudio Rouillon · Accepted solution]

I worked it out as follows. 

Created a Lookup Work items step in the automation for retrieving open issues that fall onto the Board I'm interested in.

e.g. project = XYZ and status NOT IN (Done) AND component IN (Operations) AND Sprint IS NOT EMPTY ORDER BY Sprint DESC

The sort descending ensures I get the Sprint value on the first listed issue.

Then on the create release step, I use  {{lookupIssues.first.sprint.name}}

That's it.