nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Claudio Rouillon

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.

Bill Sheboy

Hi @Claudio Rouillon

Without seeing your actual rule and audit log details...

Rather than using the list first function, I recommend using list filtering on the sprint's state to confirm it is indeed the active one. The reason is the lookup results are a list, and so is the sprint field, resulting in a list-of-lists. Thus if your work item has been in multiple sprints is will produce a list of names.

Instead, please try this:

change your JQL to include

AND sprint in openSprints()

try this smart value expression

{{#lookupIssues.first.sprint}}{{#if(equals("state", "active"))}}{{name}}{{/}}{{/}}

Kind regards,
Bill

All comments

Claudio Rouillon

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.

Bill Sheboy

Hi @Claudio Rouillon

Without seeing your actual rule and audit log details...

Instead, please try this:

change your JQL to include

AND sprint in openSprints()

try this smart value expression

{{#lookupIssues.first.sprint}}{{#if(equals("state", "active"))}}{{name}}{{/}}{{/}}

Kind regards,
Bill

Claudio Rouillon

Thanks Bill, the first suggestion is good in that by checking the Sprint is open we reduce the # of hits in the list.

As for the 2nd suggestion it's not giving me what I want.

All we need is for the Release (new version) to be the Sprint name followed by the date. And this is working fine for us.

{{lookupIssues.first.sprint.name}} : {{now.jiraDate}}

Bill Sheboy

@Claudio Rouillon would you please post images of:

your complete rule,
the action where the smart value expression is used, and
the audit log details showing the rule execution.

Those may help provide more context. Thanks!

Claudio Rouillon

Hi Bill, see attached, I cannot provide Audit Log details as the rule is yet to run next Monday at midday, but have tested the Lookup Work Items and the Create Version steps with the smart value in another (test) rule and works fine for us.

Create Version step.jpg Create Weekly Release rule.jpg

Claudio

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-cloud