Automation possiblity and logic -_-

Question

Hello,

We are trying to create an automation with multiple variable and I can't find a good way to do it.

Here is the resume :

* We have 5 fields (cascading list)
* We'd like to determine if the issue is in those case (only for the first value of the cascading list) : * 1 of the 5 fields has the value XYZ and all other are empty
* 1 of the 5 fields has the value UVW and all other are empty
* 2 of the 5 fields has the value UVW and XYZ and all other are empty

* If none of those case then add an internal comment

I assume that it is possible but I'd like your advise on how to do it and if possible without creating an unreadable automation ^^

Thanks for your help

Ste Wright · Accepted Answer

Hi @Térence LECROIX

Have you tried using the Condition IF/ELSE?

This Condition allows for AND/OR based conditions - you could then tie multiple conditions together.

For a cascading field, I'd probably use a JQL Condition for the multiple conditions, then set it to "At least one condition matches" to make it an OR statement.

You could then...

* Check if any of those situations exist
* If yes, set the relevant action
* ELSE if not, add an internal comment

Ste

Térence LECROIX · Accepted Answer

Hello thank you for your answers, that's what I was trying to use but could find the logics to operate to achieve my goals.

I think that I just found what I wanted :

With an if/else block

* 1st condition : Test if at least one of the five fields are not empty with JQL
* AND
* 2nd condition : Test for each field with JQL* ((Field 1 in (XYZ,UVW) OR is EMPTY) AND (Field 2 in (XYZ,UVW) OR is EMPTY) AND (Field 3 in (XYZ,UVW) OR is EMPTY) AND (Field 4 in (XYZ,UVW) OR is EMPTY) AND (Field 5 in (XYZ,UVW) OR is EMPTY))