Abort RITM Closure if Pending Approvals are present

[Arijit Saikia]

Hi,

I have a requirement that any RITM state cannot be changed to Closed Complete manually if there are pending Approvals for the RITM.

I have created a Before Business Rule on the sc_req_item table and used the following script, however it is still allowing me to close a RITM. PLease advise what am I missing.

(function executeRule(current, previous /*null when async*/ ) {

//Checks for any Active approval and aborts the update if active
var gr = new GlideRecord('sysapproval_approver');
gr.addQuery('document_id', current.sys_id);
gr.addQuery('state', 'requested');
gr.query();
if (gr.hasNext()) {
gs.addInfoMessage("There are open approvals which must be completed before this record can be closed");
current.setAbortAction(true);
}

})(current, previous);

[Ankur Bawiskar · Accepted solution]

@Arijit Saikia 

Did you add gs.info() to check if BR ran?

whether query is working fine?

try this

(function executeRule(current, previous /*null when async*/ ) {

//Checks for any Active approval and aborts the update if active
var gr = new GlideRecord('sysapproval_approver');
gr.addQuery('document_id', current.sys_id).addOrCondition('sysapproval', current.sys_id);
gr.addQuery('state', 'requested');
gr.query();
if (gr.hasNext()) {
gs.addInfoMessage("There are open approvals which must be completed before this record can be closed");
current.setAbortAction(true);
}

})(current, previous);

[Ankur Bawiskar · Accepted solution]

@Arijit Saikia 

Did you add gs.info() to check if BR ran?

whether query is working fine?

try this

(function executeRule(current, previous /*null when async*/ ) {

//Checks for any Active approval and aborts the update if active
var gr = new GlideRecord('sysapproval_approver');
gr.addQuery('document_id', current.sys_id).addOrCondition('sysapproval', current.sys_id);
gr.addQuery('state', 'requested');
gr.query();
if (gr.hasNext()) {
gs.addInfoMessage("There are open approvals which must be completed before this record can be closed");
current.setAbortAction(true);
}

})(current, previous);

[mcroxall]

when i try this, my record still updates, it does not abort. I do receive the message, but it will still update the record. suggestions?