Jira Automation - Smart Value to Extract Label from Issue

[jeanine]

Hello,

I am working with jira automation and smart values and am running into a blocker when trying to extract just one label (out of 2-3) from an issue. I would like to extract an application name from a label such as "app_AppXYZ" and was successful in doing so using the following: {{issue.labels.substringAfter("app_")}}

However, the issues will have 2-3 other labels and the end result comes out as "AppXYZ,,," (the 3 commas being the other labels).

I tried to use {{issue.labels.substringBetween("app_","the_other_label")}} as well as {{issue.labels.substringBetween("app_",",")}} but neither were successful. 

Any suggestions or help would be so appreciated! Thank you!
 

[Bill Sheboy · Accepted solution]

Hi @jeanine -- Welcome to the Atlassian Community!

As you note, the labels smart value is a list, so you can merge everything together, and then parse, or filter first.  Two of the ways to solve this are:

• use your current smart value, and then only grab the part before the first comma with substringBefore(): https://support.atlassian.com/cloud-automation/docs/jira-smart-values-text-fields/#substringBefore-String-separator-
• use smart value list filtering, to first get just the label you want, and then extract the application name: https://community.atlassian.com/t5/Automation-articles/Filtering-smart-value-lists/ba-p/1827588

Kind regards,
Bill

[jeanine]

Hi @Bill Sheboy 

Thank you for the quick answer!

For option one, I attempted to combine two smart values into one such as {{issue.labels.substringAfter("app_").substringBefore(",")}} but it seems it did not honor the second statement and the commas were still returned. Would you be able to provide more context as to how to use two smart values in one statement? 

Or perhaps you can help me understand where to store the first value (app name,,,) so that I may use the second smart value on it and extract only the name.

I appreciate your help!

Best,

Jeanine

[Bill Sheboy]

Sorry I wasn't more clear...Your first parsing of Labels is still going to produce a list result, and so that needs to become text (a string) before using substringBefore() or maybe remove()

Perhaps like this:

• Create a variable, storing the result of your first parsing on "app_".  Let's call it varApps
• That variable is now text, and you can remove the stray commas with {{varApps.remove(",")}}

Using remove() is better for your use case as it can handle the application name being in the middle of the results.

[jeanine]

Thank you @Bill Sheboy