Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

If else in Automation for Jira advanced field editing JSON Edited

I'd like to have a if else statement inside a JSON for the advanced field editing

https://support.atlassian.com/jira-software-cloud/docs/advanced-field-editing-json/

I have some cases where I have a if else condition to check if a field is empty because the empty field makes the JSON invalid.

If the field has a value the following example JSON is valid.

{
"fields": {
"My Custom Array":
{{My Custom Array.asJsonObjectArray("value")}}
}
}

If the field is empty, the smart value does not return anything, and the JSON gets invalid.

I tried the if from the math expressions.

https://support.atlassian.com/jira-software-cloud/docs/smart-values-math-expressions/

Here are only numeric values allowed, so I'm not able to manipulate the JSON before the empty field.

Is there any function to avoid the '"My Custom Array":' or to get a valid empty JSON object array?

I'm looking for a solution for arrays and single value fields.

2 answers

1 accepted

For array/list fields I found the following solution.

    {{#My Custom Array}}
{{#first}}"My Custom Array": [ {{/}}
{{value.asJsonObject("value")}}
{{^last}} , {{/}}
{{#last}} ] {{/}}
{{/}}

Before the first value of the array and therefore only if there is a first value we write the '"My Custom Array": ['. The downside of this solution is, that you cannot use the asJsonObjectArray(key) function.

Update 2020-05-12

@Petar Minchev 

If found another solution for arrays and one for single values:

{
"fields": {
"label_like_customfield": [
{{#label_like_customfield}}"{{.}}"{{^last}},{{/}}{{/}}
],
"array_customfield_1": [
{{#array_customfield}}{{asJsonObject("value")}}{{^last}},{{/}}{{/}}
],
"array_customfield_2": [
{{#array_customfield}}{{value.asJsonObject("value")}}{{^last}},{{/}}{{/}}
],
"single_vslue_customfield": {
"value": "{{single_value_customfield}}"
}
}
}

With this code you get an empty array or an empty value resp. if the fields are empty.

The code may need some modification depending on the custom field type. Please note that some array custom fields needs you to go into the value to call the asJsonObject() function as in array_customfield_2.

@andreasis it possible to get this function included in the smart value functions like asJsonObjectArray?

Hi @Erik Buchholz and thanks for update i test it but json is still not valid. Note: customfield_12 is mandatory and there is always value, but customfield_123 is not mandatory and when its empty (array is empty) json fails. This is it what i'm testing:

{
"fields": {
"customfield_12": {{issue.customfield_12.asJsonObjectArray("value")}},
"customfield_123":{#issue.customfield_123.asJsonObjectArray("value")}}"{{.}}"{{^last}},{{/}}{{/}}
}
}

Hi @Petar Minchev ,

so customfield_12 is never empty, right? Try the following code

{{#debug}}
{
"fields": {
"customfield_12": {{issue.customfield_12.asJsonObjectArray("value")}},
"customfield_123": [
{{#customfield_123}}
{{value.asJsonObject("value")}}{{^last}},{{/}}
{{/}}
]
}
}
{{/}}

With the debug tag you'll see the result in the audit log.

Then you need to open the array for customfield_123 manually, add an Json object for every entry in customfield_123, and add a comma for every but the last entry. Then you need to close the array manually again.

If it still fails, give us a sample of the result JSON.

Like Petar Minchev likes this

Hi @Erik Buchholz i've just tested the code and its working. When the field is empty creates empty array and when filed its not empty - value are copied correctly. There is only little correction in the code fields need to be open and closed with { } , not with [ ]. Thanks a lot and Cheers.

"fields": { ....... everything else it the same ...

}

Like Erik Buchholz likes this

Hi @Petar Minchev ,

thanks for your reply. I corrected the code and added the example to the answer. Would you mind to vote for my answer?

Best regards,
Erik

@Erik Buchholz its already masked as "Answer accepted". Have a great day :)

Like Erik Buchholz likes this

Hi Erik did you find a way to solve this problem because i have the same, i'm using automation and i'm taking values from current issue and create new one but i have 2 custom fields for which i need to use asJsonObject("value") smart value and if CF is empty JSON become valid.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

New Cloud Apps Roundup - Spring 2021

Atlassian's marketplace partners have had a very productive start to 2021! Since our last roundup, our developer community has added over 160 new cloud apps to the Atlassian Marketplace to help you...

213 views 3 20
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