Hi Danny,
I have mocked this up in a DEV and I am able to get the desired result. I did this on an Istanbul instance, and found a log entry:
{"error":{"detail":"Record doesn't exist or ACL restricts the record retrieval","message":"No Record found"},"status":"failure"}
So make sure you investigate exactly what this means to your Change Request record.
That said, this is what you need in a Risk Condition:
Use Advanced Condition = true
Use Script values = true
Order = you may want to set this highest, relative to other risk conditions
Advanced condition:
//Set the variable 'answer' to true to indicate that this risk condition matches, and false if it does not match the change request. You need to set this to your condition. it might be that you want it to run everytime, in which case, answer=true is fine
answer = true;
Script Values:
//you have access to current, being the Change Request record
if (checkRAResult(current.sys_id.toString())){
if (current.impact != '1'){
//raise Impact by one. Fine if Risk Conditions run manually, but if automated, set it as a hard value, else it will always end up as 1!
current.impact = current.impact - 1;
}
}
function checkRAResult(current){
var result = false;
//Check the task_assessment table for a record that matches this (current) Change record
var gr_task_assessment = new GlideRecord("task_assessment");
gr_task_assessment.addQuery("task", current);
gr_task_assessment.query();
//if we find a match, get the questions/responses for the assessment
if (gr_task_assessment.next()) {
var gr_survey_response = new GlideRecord("survey_response");
//instance is the sys_id of the task_assessment
gr_survey_response.addQuery("instance", gr_task_assessment.instance);
//get hold of the question we are interested in
gr_survey_response.addQuery("question.question_text", "How easy is it for the implementer to verify that the change was completed successfully?");
gr_survey_response.query();
//if we find a response
if (gr_survey_response.next()) {
//check if the response is the value we want to check
if (gr_survey_response.response == "Medium"){
result = true;
// Set the Risk/Impact using the fields above, or its possible to script them by checking the "Use Script Values" checkbox. this means, you can set any field to the value of your choice, if this Condition script sets answer = true.
}
else {
result = false;
}
}
}
return result;
}
Hope this helps!
Chris.
Hi Danny,
I have mocked this up in a DEV and I am able to get the desired result. I did this on an Istanbul instance, and found a log entry:
{"error":{"detail":"Record doesn't exist or ACL restricts the record retrieval","message":"No Record found"},"status":"failure"}
So make sure you investigate exactly what this means to your Change Request record.
That said, this is what you need in a Risk Condition:
Use Advanced Condition = true
Use Script values = true
Order = you may want to set this highest, relative to other risk conditions
Advanced condition:
//Set the variable 'answer' to true to indicate that this risk condition matches, and false if it does not match the change request. You need to set this to your condition. it might be that you want it to run everytime, in which case, answer=true is fine
answer = true;
Script Values:
//you have access to current, being the Change Request record
if (checkRAResult(current.sys_id.toString())){
if (current.impact != '1'){
//raise Impact by one. Fine if Risk Conditions run manually, but if automated, set it as a hard value, else it will always end up as 1!
current.impact = current.impact - 1;
}
}
function checkRAResult(current){
var result = false;
//Check the task_assessment table for a record that matches this (current) Change record
var gr_task_assessment = new GlideRecord("task_assessment");
gr_task_assessment.addQuery("task", current);
gr_task_assessment.query();
//if we find a match, get the questions/responses for the assessment
if (gr_task_assessment.next()) {
var gr_survey_response = new GlideRecord("survey_response");
//instance is the sys_id of the task_assessment
gr_survey_response.addQuery("instance", gr_task_assessment.instance);
//get hold of the question we are interested in
gr_survey_response.addQuery("question.question_text", "How easy is it for the implementer to verify that the change was completed successfully?");
gr_survey_response.query();
//if we find a response
if (gr_survey_response.next()) {
//check if the response is the value we want to check
if (gr_survey_response.response == "Medium"){
result = true;
// Set the Risk/Impact using the fields above, or its possible to script them by checking the "Use Script Values" checkbox. this means, you can set any field to the value of your choice, if this Condition script sets answer = true.
}
else {
result = false;
}
}
}
return result;
}
Hope this helps!
Chris.
