populate appovers list in custom field on RITM

[Ash41]

Hi Team, 

I want to populate Approvers list in custom field on RITM. I have wrote below BR on RITM table after- insert/update.

Users are not populating, not sure what's wrong. custom field is glide list type.

Condition: current.approval.changesTo('requested')

(function executeRule(current, previous /*null when async*/) {
	var gr = new GlideRecord('sysapproval_approver');
	gr.addQuery('sysapproval', current.sys_id);
	gr.query();
	var myString='';
	if(gr.hasNext()){
		while(gr.next()){
			myString = myString +gr.approver+',';
			gs.log(current.number+' Inside while loop Approval List ='+myString);
		}
		myString=myString.slice(0, -1);
		gs.log(current.number+' Outside while loop Approval List ='+myString);	
		current.u_approvers=myString;
		gs.log(current.number+' Outside while loop current.u_approvers ='+current.u_approvers);
		current.update();
	}
})(current, previous);

[Ankur Bawiskar]

@Ash41 

Your BR should be on Approval table but the answer you marked as correct says the BR should be on RITM table which is wrong.

Could you please ensure you mark appropriate response as correct so that it doesn't confuse users in future?

[Ankur Bawiskar]

@Ash41 

your BR should be on sysapproval_approver table and not RITM

BR: After Insert

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

	var gr = new GlideRecord('sc_req_item');
	gr.addQuery('sys_id', current.sysapproval);
	gr.query();
	if(gr.next()){
		if(gr.u_approvers == '')
			gr.u_approvers = current.approver;
		else
			gr.u_approvers = gr.u_approvers + ',' + current.approver;
		gr.update();
	}

})(current, previous);

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ash41]

Hi Ankur, 

Above script works but issue is it will keep on adding users to custom field, we have 1st level approver and 2 level approvers, once 1st level approvals are approved, need to clear value in custom field and update with new approvers.

[Ankur Bawiskar]

@Ash41 

have after update BR on Approval table with state as Approved

Then search for that approver and remove it from that list

[Ankur Bawiskar]

@Ash41 

You mentioned as per your original question to just add approvers and didn't mention to remove them once approved.

Also you mentioned that script I shared work fine.

Could you please mark my response as correct as that worked for you?

Thanks in advance