Using cascading field values as conditions for assigning an issue

[Susan Waldrip]

Hi, I'm trying to auto-assign an issue to a particular person if certain conditions are met. The conditions are determined by customer selection of values in a cascading selection field. I've tried using different branching, changing the order of IFs and Actions, but can't get it to assign the issue to a specific person. Would appreciate some guidance on what I may be doing wrong.

Here's the automation and automation audit log error, the "If any match" is an IF with two JQL conditions:

[Bill Sheboy · Accepted solution]

Hi @Susan Waldrip 

Your rule is using a JQL condition and using the smart values that way will not produce valid JQL.  Instead please try a Smart Values Condition:

https://support.atlassian.com/cloud-automation/docs/jira-automation-conditions/#--smart-values---condition

Kind regards,
Bill

[Susan Waldrip]

Hi @Bill Sheboy , thanks for looking at my automation mess and trying to make some sense of it! I had tried to use your suggestion previously and tried again now but couldn't find a way to set up "IF 'x', then IF 'y' OR 'z', THEN assign the issue to someone. However, your suggestion led me down a path that provided the answer using a JQL statement!

For anyone looking for help with this cascading field scenario:

My custom cascading field is named Application Related with parent options "Yes", "No", and "I don't know". The "Yes" parent option has three child options, two of which are "Make an Enhancement" and "Develop a new application". The "I don't know" parent option has no child options. The syntax needed in JQL to reference parent and child cascading field options, which is what I've been struggling with, is:

"Custom Cascading Field Name[Select List (cascading)]" IN (cascadeOption("parent1 option with no child option"), cascadeOption("parent2", "child1"), cascadeOption("parent2", "child2"))

So the resulting JQL statement that worked for me is:

"Application Related[Select List (cascading)]" IN (cascadeOption("I don't know"), cascadeOption("Yes", "Develop a new application"), cascadeOption("Yes", "Make an enhancement"))

FYI, the "parent1" and "child1" references above have nothing to do with the order of the parent and child options in the cascading field, just enter the name of a parent option and a related child option for that field and use the syntax shown if you have multiple parent or parent-child conditions you need to use.