You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.
Join groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
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.
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
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}},{{/}}{{/}}
}
}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ...
}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.