Automation on Automation- with color coding

kitty.miranda

Hi -  

I created a BRAG colour field - RAID Level (custom field that has the colour coding added based on the hack mentioned in this Atlassian thread, see my screenshot below).... I added an automation to this field based on the various value ranges in another numeric custom field RAID Severity. 

 

For example:



In the same way I have created other 3 automation rules to set the colour based on the value ranges of the RAID Severity (set Amber 12 to 16; set Yellow for values 9 to 12) 

(P.S. - RAID Severity is auto-calculated through a Jira Automation) 

I am facing some issues around this.

1. The RAID Level does not auto-set if the RAID Severity (auto-calculation is on)
2. I turned off the RAID Severity,  and found that the RAID Level value is set when I manually put in a value in RAID Severity. Also, if I change the value from 3 to 6 the RAID Level colour does not change from Blue to Yellow. The initial colour is retained no matter the value I put in.

This brings in a lot of questions to mind such as does Jira support automation on automation. Is there a way to check for multiple OR conditions (not AND) at once that is have one rule for colour coding instead of 4 different rules and is there way to tell JIRA which rules runs when. 


PLEASE HELP!!!

Ste Wright

Hi @kitty.miranda 

This is possible; I also consolidated it into one rule for ease.

The rule uses...

• The Custom Field Option IDs rather than the value to set the option
• A lookup table rather than multiple IF/ELSE statements

---

Prerequisites

You're going to use the Option IDs in the rule to set the field value - to get these:

• Go to Settings (cog icon in top-right) > Issues
• Select Custom Fields from the left-hand menu
• Locate the "RAID Level" field
• Select the breadcrumbs (...) on the right-hand side, and select Contexts and default value
• Next, select the hyperlink Edit Options
• In the Actions column, hover over each Edit hyperlink
• Take note of each options' ID
  • It's the value at the end of the URL - eg. &selectedValue=10123

Also take note of the RAID Severity Custom Field's ID at the same time:

• Go back to the Custom Fields screen
• Select the breadcrumbs (...) on the right-hand side, and select Edit Details
• Take note of the Custom Field ID for RAID Severity, which is at the end of the URL - eg. ?id=10456

---

Rule

• Trigger: Field Value Changed
  • Field to Monitor = RAID Severity
• Action: Create Lookup Table
  • Table Name = raidLevel
  • Table Entries...
    • Row 1
      • Key = 0
      • Value = 10123
    • Row 2
      • Key = 1
      • Value = 10123
    • ...etc
• Action: Edit Issue
  • Field = RAID Level
    • Value = {{raidLevel.get(issue.customfield_10456.format("#"))}}
• Other: Modify Rule Details
  • Check Allow rule trigger to TRUE (checkbox)

---

Notes:

• The Rule Details section should allow your RAID Severity rule to activate the other one
• The Create Lookup Table will require as many rows as you have numeric values in RAID Severity...
  • The Keys are those numeric values (eg. 1-20 = 20 rows)
  • The Value should be the Option ID - eg. 10123 might be for "Blue"
• The Edit Issue Action then sets the field value, based on checking each row. It uses a dynamic smart value to do this.

---

Let us know if this works for you!

Ste