Jira automation to set custom field values

[mon33h]

Hi,

I am setting up an advanced roadmap, however the custom field I would like to display on it is unsupported (the field is a select cascading list). 

I therefore thought if I create two single select lists with the same options as each of the cascade list levels; I could use Jira automation to populate them based on the options selected for the cascading list. I can then use the two single select lists in the advanced roadmap (as they are supported). 

I have no idea how to add JSON code to do this, so I am wondering if someone can help with this. An example of the list is as follows:

Cascading list:

• Compliance
  • 1.1 - xx
  • 1.2 - yy
• Infrastructure
  • 3.1 - aa
  • 3.2 - bb

(The cascading list is not mandatory so either one, both or none of the options could be selected.)

The two single select lists I create for the above will look like:

List 1:

• Compliance
• Infrastructure

List 2:

• 1.1
• 1.2
• 3.1
• 3.2

So the code can basically copy the value from the first cascading list level into List 1, however List 2 will contain a shortened version of the list options from the second cascading list level, so it cannot be a direct copy across, it will have to be an "If cascading list level 2 = [X] then populate List 2 with [Y]".

Alternatively if there is another way I can get the values of this cascading list on my advanced roadmap, I would be keen to find out how.

Appreciate any assistance anyone can offer :)

Thank you!

[mon33h · Accepted solution]

I managed to get this working with an If/Then/Else statement to cater for clearing/populating the two single select lists when the cascading list value changes.

Code used for populating the first single select list based on the parent of the cascading list:

{
"fields": {
"customfield_10225": {
"value": "{{customfield_10030.value}}"
} 
}
}

Code used for populating the second single select list based on the child of the cascading list:

{
"fields": {
"customfield_10224": {
"value": "{{triggerIssue.fields.customfield_10030.child.value.split(" ").get(0)}}"
} 
}
}

For clearing the single select lists when the cascading list values are cleared, I established if the parent or child value of the cascading list was cleared using the following code:

If {{triggerIssue.fields.customfield_10030.value}} equals empty; for the parent.

If {{triggerIssue.fields.customfield_10030.child.value}} equals empty; for the child.

[Vinutha GR]

I am using {"fields":{"customfield_10023":{"value":"test"}}} - Its giving the following error. Operation value must be a string

[Bill Sheboy]

Hi @mon33h 

Perhaps look at this information and advanced edit with JSON to learn how to access (and edit) the various types of fields: https://support.atlassian.com/cloud-automation/docs/advanced-field-editing-using-json/#Cascading-select-custom-field

While writing your rule, I recommend that you initially write the smart values to the audit log to confirm you are getting what you expect, and then add the issue edit actions.

Kind regards,
Bill

[mon33h]

Hi @Bill Sheboy,

Thank you for your reply.

I did see that page, however my issue is that I wouldn't know how to structure the code (I know nothing about JSON) -  so was hoping someone would be able to give an example for this case for me to start with.

Thank you,

Manola

[Bill Sheboy]

At that top of that page, it shows how to structure an edit with JSON.  And the link I provided is to the specific examples for the type of field you described: cascading select. 

I recommend trying to create the rule with this information; writing rules is a lot about experimentation and so starting a rule is a good way to start.  The community can help if you see errors with the rule/audit log, however we won't know the specifics you need for your Jira instance, such as the custom fields.

If you cannot find the exact smart values for your field, please try the information in this how-to article: https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/