The review ui action in our change request has the following conditions set along with the script below. This stops the move to review state until the tasks are closed.
function moveToReview(){
//Check for remaining tasks before moving to Review
g_form.clearMessages();
//Type appropriate comment here, and begin script below
var gr = new GlideRecord("change_task");
gr.addQuery("change_request","=",g_form.getUniqueValue());
gr.addQuery("state","<","3"); //anything less than 3 is not closed
gr.setLimit(1);
gr.query(); //purposefully not async
if(gr.next()) {
g_form.addErrorMessage("Cannot move to Review state while Change Tasks are open");
return false;
}
else {
//no remaining tasks, move to Review
var ga = new GlideAjax("ChangeRequestStateHandlerAjax");
ga.addParam("sysparm_name", "getStateValue");
ga.addParam("sysparm_state_name", "review");
ga.getXMLAnswer(function(stateValue) {
g_form.setValue("state", stateValue);
gsftSubmit(null, g_form.getFormElement(), "state_model_move_to_review_new");
});
}
}
if (typeof window == 'undefined')
setRedirect();
function setRedirect() {
current.update();
action.setRedirectURL(current);
}
Hi - this may be what you're looking for.
We have a before update business rule set as follows with the script below on the Advanced tab
Advanced tab
Condition: new ChangeRequest(current).changesToClosed()
Script:
(function executeRule(current, previous /*null when async*/) {
if (hasOpenTasks(current.sys_id)) {
gs.addErrorMessage(gs.getMessage('Unable to close the Change request as there are open Change tasks'));
current.setAbortAction(true);
//action.setRedirectURL(current);
}
function hasOpenTasks(sys_id)
{
var cTaskAgg = new GlideAggregate('change_task');
cTaskAgg.addQuery('change_request', sys_id);
cTaskAgg.addQuery('u_bypass_close_check','=','false');
cTaskAgg.addActiveQuery();
cTaskAgg.addAggregate("COUNT");
cTaskAgg.query();
if (cTaskAgg.next())
return (cTaskAgg.getAggregate("COUNT") > 0);
return false;
}
})(current, previous);
