Get active sprint in automation

Guy Grinberg May 4, 2020

Hi,

 

I want to get the name of the active sprint of an issue because with this name I'm changing a custom field in this issue.

 

In the beginning, I tried 

{{issue.Sprint.last.name}}

But then I found out that the active sprint (the last sprint that the issue was added to) is not the last in the list, nor the first, I've already seen active sprint as first in the list, last, and middle.

 

so I tried something like this:

{{#issue.sprint}}{{#=}}IF({{isClosed}},,{{name}}){{/}}{{/}}

 so I will get only the name of an active sprint. but for some reason, math expression does not work inside a list iteration.

I tried to run the expression outside of the iteration and it worked:

 {{#=}}IF({{issue.sprint.last.isClosed}},,{{name}}){{/}}

and I tried to run a simple expression inside the iteration:

 {{#issue.sprint}}{{#increment}}4{{/}}{{/}}

 and it didn't work as well. (the log was empty)

 

And I could not find any suitable solution with JQL, I looked at openSprint()/closedSprint() but this does not help me, those functions says if the issue is inside an active sprint or, but does not says which sprint

 

small note:

this automation is triggered on sprint changed, that's mean every time an issue is added to a sprint, but I could not find how to get the new sprint variable, only a list of all sprints

2 answers

0 votes
André Richter
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 8, 2024
{{#issue.sprint}}{{#if(not(isClosed))}}{{name}}{{/}}{{/}}

 

works for me

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 25, 2020

Hi @Guy Grinberg 

To back up a bit: what is the problem you are trying to solve? 

I am asking because perhaps starting with a triggering issue when the sprint field changed is not helping solve the problem.  Maybe there is a different trigger to use, such as scheduled rule.

Thanks, and best regards,

Bill

Guy Grinberg September 6, 2020

Hi @Bill Sheboy 

We have a special field that determines the team that this issue belongs to.

We have automation that changes this field according to the prefix of the sprint name when an issue is added to the sprint.

The problem is that we cannot know what is the active sprint, and what is the old sprint. so if an issue moved between an old sprint of one team to a new sprint of another team we will get a random team.

 

Guy.

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 8, 2020

Hi Guy,

Thanks for explaining what you are trying to accomplish.  And just to confirm, you have multiple teams doing work within on project and separate sprints for each team.  Correct?

Unfortunately, there appears to be no way to sort the values in a list field (e.g. Sprint) by an attribute (e.g. date) to get what you want.

How about this as a work around:

  • Add a custom field for the active sprint to issues
  • Use automation to set the field when the sprint starts
  • Use automation to update the field if the sprint field changes and it is an active sprint
  • Use the custom field of active sprint to determine your team field

 

__Bill

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events