Automation rule with active sprint

Question

Hello,

I created a field named "Sprint created".

I would like that this field is equal to the active sprint by an automation rule when issue is created.

The problem is that i have each time several sprint which are opened :

- Bug

-sprint00.00

- TMA

The field must be equal to the open sprint which begin by "sprint"

I know how to create an automation rule. But I don"t know how to build it in order to have the good value

Bill Sheboy · Answer

I understood what you asked, and the solution I described would meet that need.

Assuming the use of the Lookup Issues action with this JQL:

project = yourProjectKey AND sprint = "sprint" AND sprint IN openSprints()

Each issue in the results would contain the matching issues.  But they could have been in multiple sprints, and so the name of the "active" one must be extracted and compared your sprint name prefix.

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

This would iterate over the values in the sprint field for the first issue, and for any active sprints where the name starts with "sprint", return the sprint name.

Please note well: successfully using automation rules requires learning and experimentation.  When something does not work as you expect, try using the Log action to write results to the log and incrementally adjust rules to learn what is happening and why.

Aurélie Pilette_1tqqnx · Answer

Hello,

The objective is to make a graph in order to have the bugs created vs bugs resolved in a sprint.

Like I don't find how to make the graph on Jira, I use Google sheet for the extract and looker studio for the graph.

For the resolved is not a problem, i have already the field said in which sprint the bug was resolved.

But, I don't have the value of the sprint during the bug was created.

That's why I created a field : "sprint created" and I would like that the field will populate with active sprint.

My problem is that on my project, I have always 3 srpints active.

So, that's why, I ask how to populate my field by the value : "Sprint active and the name begins by sprint."

Anyway, if you have an issue to have resolved vs created y sprint, I take it

Aurélie Pilette_1tqqnx · Answer

Hi,

it is not exactly what I want. bcause i have not one active sprint. I have always three active srpint on my project.

What I want is : "active sprint and the active sprint must begin by sprint."

What i don't find is how to condition "My active sprint must begiin by sprint."

Do you know how can I condition by the sprint name on automation rule ?