How can I build up a concatenated string field in a branch to update a short text field

Rees, Ian

I have a custom field of type Select List (multiple choices) - this is called Program Impact.  Whenever this is updated, I want to update a short text field (called PI Abbr) with a string which is a concatenation of abbreviations for the multiple choices in the Program Impact field.

e.g. If Program Impact is updated and the choices  

"Long textA" and "Long textC" are seldected, the resultant "PI Abbr" field contains

"CodeN, CodeZ". This is based on a lookup table in the rule shown below

LongtextA	CodeN
LongtextB	CodeY
LongtextC	CodeZ
LongtextD	CodeA

The rule is a single issue rule so the branch executes inline, so I have created a variable 

varAbbrStr outside of the rule and was hoping to update that in the branch but can't work out how to concatenate those values.  Alternatively I would concatenate the new abbreviation in each branch to the {{issue.PI Abbr}} field value but I think that would mean refetching every loop which will impact performance. In the rule, when the value changes for the Program Impact rule, I clear issues 'PI Abbr' field and create an empty variable varAbbrStr.. In the branch, I iterate though each value set in {{issue.Programme Impact}}, lok up its abbreviated equivalent in the lookup table and attempt to build a concatenation of each of the abbreviations lookup that I can use to finally set the "PI Abbr" field. 

I have a workaround which is creating PI Abbr also as a multi-select and I could just set that each time arounf the loop.  I prefer not to do that because then changes to the abbreviations means maintenance in two places, Jira custom field and the automation script

 

Bill Sheboy

Hi @Rees, Ian 

Short answer: This scenario requires using an inline, iterator over the multiple-select, option field and a series of chained replace() functions to convert to the code / abbreviation string value.  For example:

{{issue.myMultipleSelectField.value.join(", ").replace("LongtextA", "CodeN").replace("LongtextB", "CodeY")...}}

 

For more information...

You note this:

The rule is a single issue rule so the branch executes inline...

That is not correct.  An issue branch on one-and-only-one issue (e.g., Branch to Current Issue) is executed inline, as if the branch did not exist.  But branches which could-be-on-more-than-one-thing (e.g. branch on linked issues, advanced branch, etc.) are run in parallel and asynchronously.  There is no way to accumulate the value of the text string using a branch. 

There is a long standing, open suggestion to allow configurable parallel / serial execution.  That is currently shown as "in progress" but there is no hint from the Atlassian team what they are planning to implement.  Please watch here to learn more: https://jira.atlassian.com/browse/AUTO-32

 

Additionally, you are trying to use a Lookup Table for the replacement values.  That cannot work with a long-format iterator because the table data is not visible once inside the iterator.  That is, the following will not work:

{{#issue.myMultipleSelectField}}{{varLookupTab.get(value)}}{{^last}}, {{/}}{{/}}

This is another long standing, open defect / suggestion.  My understanding is the Atlassian team has repeatedly tried to address it without success.  Please watch here to learn any progress: https://jira.atlassian.com/browse/AUTO-490

 

This leaves three possible workarounds:

• Use the chain of replace() functions I described
• Change the multiple-select, options to include both values, and then parse them when needed.  For example, the first list option would become: "LongtextA - CodeN"
• Build an external service capable of performing the replacement and call that from the rule using the Send Web Request action

 

Kind regards,
Bill