How to check approval state for change request

anilkumarsharma · ‎01-24-2023

@Gunjan Kiratkar

Good morning All,

i want to check that state of the approval are approved not against change number CHG0000087 if all are not approved the send notification.

Please let me know How will I check? Please help.

i used hasnext() in while loop to check the record but background script went in infinite loop.

var gr = new GlideRecord('sysapproval_approver');

gr.addEncodedQuery('sysapproval.number=CHG0000087^state=approved');

gr.query()

gs.info("Print number:"+gr.getRowCount());

while(gr.next()){

gs.info("print state:"+gr.state);

}

Gunjan Kiratkar · ‎01-24-2023

Hi @anilkumarsharma

You can do something like below:-

var gr = new GlideRecord('sysapproval_approver');
gr.addEncodedQuery('sysapproval=e2cdf552db252200a6a2b31be0b8f57f^state!=not_required^ORstate=NULL'); //Copy encoded query from list view
gr.query()
var allCount=gr.getRowCount();
var approvedCount=0;
while(gr.next() && gr.state=='approved'){
approvedCount++;
}
if(approvedCount==allCount){

gs.eventQueue("EventName");

}

Please Mark My Response as Correct/Helpful based on Impact

Regards,
Gunjan Kiratkar
2X ServiceNow MVP
Community Rising Star 2022
Youtube : ServiceNow Guy

View solution in original post

anilkumarsharma · ‎01-25-2023

Thanks, Sir, for update.

How to check approval state for change request

Please Mark My Response as Correct/Helpful based on Impact

Regards,Gunjan Kiratkar2X ServiceNow MVP Community Rising Star 2022Youtube : ServiceNow Guy

Regards,
Gunjan Kiratkar
2X ServiceNow MVP
Community Rising Star 2022
Youtube : ServiceNow Guy