Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Carriage return between values in a field (using JQL)

I'm running some automation that displays any items that were checked off for a custom multi checkbox. The default way it displays is each value separated by a comma. Ideally I'd like for each item to be displayed on a new line. Can I format it so it displays that way?

 

So right now I have:

Service {{issue."Services affected"}}

and when the automation runs and send the email it shows:

item1, item2, item3, item4

I'd like it to be:
item1
item2
item3
item4

1 answer

Hi @dennish_dcsorg_com 

You mention solving this with automation.  Have you tried to either use the replaceAll() function to substitute a newline for the commas, or use split() and join() to do the same thing?


Best regards,

Bill

Can you assist with what the syntax for that would be? I'm not the expert on smart values in JA.

 

This is the actual line I'm using to display the checked values.

 

Service {{issue."Services affected"}}

Hi @dennish_dcsorg_com 

A lot about using automation rules is experimentation, so I encourage you to try things to learn what does and doesn't work.  The documentation will not have all of the answers for every use case, so consider writing a rule, and if you have a problem then post that rule and the audit log for the community to offer help.

To do what I was suggesting, you could:

  • use the Create Variable action to save the field.  This will convert it into a string with comma-separated values.  For example, you could name the variable: varServicesAffected
  • next you can use the replaceAll() text function to substitute the commas for newline characters to produce the list.  For example:
{{varServicesAffected.replaceAll(",", "\n")}}

 

Best regards,

Bill

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira

⏰ Day in the life of a Jira Admin!

Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...

931 views 2 22
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you