Update priority based on urgency and impact through ScriptRunner

Zaldy Parian

Hi all,

First time user of ScriptRunner here. I searched the Community field for similar situation as mine but cannot find one that works for me. Anyway, I got 2 fields that set the priority on -- urgency and impact. The priority is defaulted to 'P4 - Low'. The matrix is like this....

	URGENCY
IMPACT	Critical	High	Medium	Low
Extensive	P1-Critical priority	P2-High priority	P3-Medium priority	P4-Low priority
Significant	P1-Critical priority	P2-High priority	P3-Medium priority	P4-Low priority
Moderate	P2-High priority	P3-Medium priority	P4-Low priority	P4-Low priority
Minor	P3-Medium priority	P4-Low priority	P4-Low priority	P4-Low priority

And my script which I added in the Script Listener is this...

def urgency = issue.get("customfield_10034")
def impact = issue.get("customfield_10004")

def priority = ""

if (urgency == "Critical" && impact == "Extensive") {
priority = "P1 - Critical"
} else if (urgency == "Critical" && impact == "Significant") {
priority = "P1 - Critical"
} else if (urgency == "Critical" && impact == "Moderate") {
priority = "P2 - High"
} else if (urgency == "Critical" && impact == "Minor") {
priority = "P3 - Medium"
} else if (urgency == "High" && impact == "Extensive") {
priority = "P2 - High"
} else if (urgency == "High" && impact == "Significant") {
priority = "P2 - High"
} else if (urgency == "High" && impact == "Moderate") {
priority = "P3 - Medium"
} else if (urgency == "High" && impact == "Minor") {
priority = "P4 - Low"
} else if (urgency == "Medium" && impact == "Extensive") {
priority = "P3 - Medium"
} else if (urgency == "Medium" && impact == "Significant") {
priority = "P3 - Medium"
} else if (urgency == "Medium" && impact == "Moderate") {
priority = "P4 - Low"
} else if (urgency == "Medium" && impact == "Minor") {
priority = "P4 - Low"
} else {
priority = "Low"
}

return priority

But when I test it during create or edit mode, nothing happens.

 

Please advise.

Thanks,

PD Sheehan

Can should share some extra details on your listener configuration?

• What event is is listening to?
• And is this all of your code? Where is the part that actually sets the priority field?

I have a similar situation and it can be greatly simplified with the use of groovy map/data structure.

I'm not super well versed in cloud scripts, but I took my best shot at building a listener that will take the urgency and impact (just like in my sever environment) to determine the correct priority and then update the issue with that priority

// get custom fields so we can find the id of the urgency and impacts
def customFields = get("/rest/api/2/field")
        .asObject(List)
        .body
        .findAll { (it as Map).custom } as List<Map>

def urgencyCfId = customFields.find { it.name == 'Urgency' }?.id
def impactCfId = customFields.find { it.name == 'impact' }?.id

//this was added by the scriptrunner cloud example as a way to check the listener is only applied to the correct project
def projectKey = "TP" //update to match the expected project
if (issue == null || ((Map) issue.fields.project).key != projectKey) {
logger.info("Wrong Project ${issue.fields.project.key}")
return
}

//get the values from your issues
def urgency = issue.fields[urgencyCfId] as Map
def impact = issue.fields[impactCfId] as Map

if (urgency == null || impact == null) {
logger.info("Missing urgency or impact. Can't set priority")
return
}

//this is the simplified matrix
def matrix = [
Critical: [Extensive: '1', Significant: '2', Moderate: '3', Minor: '4'],
High    : [Extensive: '1', Significant: '2', Moderate: '3', Minor: '4'],
Medium  : [Extensive: '2', Significant: '3', Moderate: '4', Minor: '4'],
Low     : [Extensive: '3', Significant: '4', Moderate: '4', Minor: '4']
]
//convert the simple numbers into full priority name. Alternatively, skip this part and and plug in the priority ids in the matrix above
def priorities = [
'1': 'P1-Critical priority',
'2': 'P2-High priority',
'3': 'P3-Medium priority',
'4': 'P4-Low priority'
]
def priorityNumber = matrix[urgency.value][impact.value]
def priorityName = priorities[priorityNumber]
//I tried to use the queryString("priorityName", priorityName) but it was not working
def priority = get("/rest/api/2/priority/search")
        .queryString("projectId", issue.fields.project.id)
        .asObject(Map)
        .body.values.find { (it as Map).name == priorityName }

//update the issue with the new priority
put("/rest/api/2/issue/${issue.key}")
        .header("Content-Type", "application/json")
        .body([
fields: [
"priority": priority
                ]
        ])
        .asString()