How to cancel approvals - if change request got (reset to new) state

[thaduri sai]

Hi Team,

We have a requirement in change request - In change request we have UI button (Reset to New).

In change we are added manuall approvals. Now the change is in Assess state waiting for approvals. Some of the groups are "Approved" and other groups are "Requested" state.

If change got (reset to new) state - The approved groups are still showing in groups approvals.

How can we acheive to cancel all approvals if change reset new through Ui action button.

Thanks,

Saikrishna

[Sandeep Rajput · Accepted solution]

@thaduri sai Create a business rule on Change Request table as follows.

Here is the BR script.

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

	// Add your code here
	var approvalRec = new GlideRecord('sysapproval_approver');
	approvalRec.addQuery('document_id',current.sys_id);
	approvalRec.query();
	while(approvalRec.next()){
		approvalRec.setValue('state','not_required');
		approvalRec.update();
	}


})(current, previous);

[Sandeep Rajput · Accepted solution]

@thaduri sai Create a business rule on Change Request table as follows.

Here is the BR script.

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

	// Add your code here
	var approvalRec = new GlideRecord('sysapproval_approver');
	approvalRec.addQuery('document_id',current.sys_id);
	approvalRec.query();
	while(approvalRec.next()){
		approvalRec.setValue('state','not_required');
		approvalRec.update();
	}


})(current, previous);

[babbi]

Hi @Sandeep Rajput ,

we have retrun above BR - But it is working for approvals only  - still its showing group approvals as approved.

In approvals all are cancelled this is fine.

Thanks,

saikrishna

[Sandeep Rajput · Accepted solution]

@babbi @thaduri sai Update the BR as follows.

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

	// Add your code here
	var approvalRec = new GlideRecord('sysapproval_approver');
	approvalRec.addQuery('document_id',current.sys_id);
	approvalRec.query();
	while(approvalRec.next()){
		approvalRec.setValue('state','not_required');
		approvalRec.update();
	}


	var approvalGroupRec = new GlideRecord('sysapproval_group');
	approvalGroupRec.addQuery('parent',current.sys_id);
	approvalGroupRec.query();
	while(approvalGroupRec.next()){
		approvalGroupRec.setValue('approval','not_required');
		approvalGroupRec.update();
	}

})(current, previous);

Hope this helps.

[babbi]

Thank you @Sandeep Rajput