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

thaduri sai · ‎06-20-2023

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 · ‎06-20-2023

@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);

View solution in original post

Sandeep Rajput · ‎06-21-2023

@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.

View solution in original post

babbi · ‎06-27-2023

Thank you so much @Sandeep Rajput ,

Am unable to see the mark it as resolve button here in commuity.

Thanks,

Saikrishna

Sandeep Rajput · ‎06-27-2023

@babbi Since this question was raised through your other account (@thaduri sai), you will only find the accept solution button once you login with @thaduri sai user id.

thaduri sai · ‎06-27-2023

@Sandeep Rajput - Accepted.

Thanks for the help.

Thanks,

Saikrishna

Sandeep Rajput · ‎06-29-2023

Thanks a lot.

babbi · ‎09-22-2023

Hi @Sandeep Rajput ,

After along time - Hope you are doing fine.

You have suggested above approvals script regarding change management. It is working fine as expected - But if change is requested in state one of the approver will rejected the change - (Rejected) is showing for all other requested groups also.

Here after requested approvals for 4 groups - One of the group member is rejetced the change. But Its showing rejected for all other 3 groups.

Our requirement is if rejected by someone of approver. Only that respective group will be shows as rejected. Other than groups shows as cancelled in state. Could you please help on this.

Thanks for the advance,

Thanks,

sai