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
{{#issue.sprint}}{{#if(not(isClosed))}}{{name}}{{/}}{{/}}
works for me
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
__Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.