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; } } }

Using Jira Automation to label tickets in a sprint using a sub-string of the Sprint Name

Nigel Clulow

Hi, I'm looking help to set up a JIRA Automation rule that will label all tickets in a sprint (on sprint start) with a substring of characters from within the sprint name.

The desired label is to be "PI XX.X" where X represents a number and this could occur anywhere in the sprint name.

I have created an automation rule that will work (on sprint start) if this desired substring appears as the first 7 characters in the sprint name, but I want to make this more versatile to be able to find this substring wherever it occurs in the sprint name.

{
"update": {
"labels": [{
"add": "{{sprint.name.substring(0, 7).replace(" ", "_")}}"
}
]
}
}

I have been looking into resolving this with REGEX pattern matching, and have a REGEX pattern that will find the required substring, but I've not yet been able to use this Match to create the desired label:

{
"update": {
"labels": [{
"add": "{{sprint.name.match(PI\s\d{2}\.\d)}}"
}
]
}
}

Accepted answers

Bill Sheboy

Hi @Nigel Clulow

As the sprint field is a list, I wonder if using match() is potentially also producing a list of results. Try writing that smart value with the regular expression to the audit log to see if that is the case. If so, perhaps then referencing just one item from the list would meet your need.

Kind regards,
Bill

All comments

Bill Sheboy

Hi @Nigel Clulow

Kind regards,
Bill

Nigel Clulow

Hi Bill, thanks for your reply. I've not made progress with the MATCH approach, so I was wondering if there is a way to use Substring with Indexof and a set length? For example, find the Index of the string "PI ", and use this index as the starting parameter in the Substring function? The second challenge with this is the End INT needs to be this Index Value + 7.

I've come back to this as labelling from the substring extract worked, but was limited by the desired text needing to be at the start of the sprint name.

Bill Sheboy

My testing in other rules indicated that smart values could not consistently be used as parameters to functions like substring. There is something about the order of evaluation that seems to lead to nulls in the middle, breaking the calls.

I recommend giving match() another try, perhaps by first listing examples of what the sprint name could contain, and then practice writing the expressions to the audit log. Once you have something that works, try to add the labels with it. The tricky part of this is the regular expression, as the help indicates:

The underlying implementation is based on Java's Pattern class and uses Matcher.find() to find matches.

And I recall seeing several things defined for the Java implementation of regular expressions which are not supported by automation rules in match(). Try simpler expressions, when possible.

Also, I do not believe you need to use JSON to add a label with smart values; instead you can type in the expression with Edit Issue, Labels, add label...the smart value will appear below the field when you type it, and then you may select it for use.

Nigel Clulow

Hi @Bill Sheboy , thanks for your input. I've managed to create a working rule using MATCH():

{
"update": {
"labels": [{
"add": "{{sprint.name.match(".*(PI.....).*").replace(" ", "_")}}"
}
]}
}

This Identifier + Wildcards lifts the desired text string and uses that to create the label:

Action details:

Edit Issue:
Issues edited successfully
LOG ACTION
Log
Match value is: "PI_22.4"
LOG ACTION
Log
Sprint name is: "team 2 - PI 22.4 - Sprint 3"

Tightening up the pattern matching to look specifically for PI XX.X would be great to remove the risk of "PI" occurring earlier in the sprint name before the desired label, and any guidance you might have on that aspect would certainly be appreciated.