Set Approval to Requested via Business rule

[Jan Janou_ek]

Hello folks!

I would like to ask you for help with this - I need to create approval from members of Change Manager group when anybody creates a new Change with model "Normal large" and set Approval to "Requested".

I found the script below and I am able to generate approval task to both member of that group from Business rule on the "Change_request" table. But I can´t to use "Approval" field in UI Policy condition because it is still "Not yet requested". Is there any way how to change it also?

Thx!

Jan

(function executeRule(current, previous /*null when async*/) {
	
var appgroup = "87950d301b084910d73065fde54bcbd9"; 
var getapprovers=new GlideRecord('sys_user_grmember');
getapprovers.addQuery('group',appgroup);
gs.log('approver grp', appgroup);
getapprovers.query();
while(getapprovers.next())
{

gs.log('approver name',getapprovers.toString());


var gr=new GlideRecord('sysapproval_approver');
gr.initialize();


gr.sysapproval = current.sys_id;


gr.approver = getapprovers.user.sys_id.toString();

gr.state='requested';

gr.insert();
}

[johnfeist]

Hi Jan,

The approval field on the change record is simply a string so you can simply include setting that value somewhere in your business rule.  Just remember that if you rule is after update, you'll need to save that change record again.

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

[Jan Janou_ek]

Hello John,

but how can I change value for "Approval" in the first image? BR will be only after insert a new change.

[Aman Kumar S]

I ran the same code in my instance, its working as expected and states are being set to "Requested".

Can you check if you have BR that might be restricting your state transition to "Requested"?

[Jan Janou_ek]

Hi Aman,

yep, it works on the change form but I also need to set "Approval" on the list of all Changes as you can see on this screen or the link - nav_to.do?uri=%2Fchange_request_list.do%3Fsysparm_userpref_module%3D3f1711211b6c0990d0315205604bcbab%26sysparm_query%3Dactive%253Dtrue%255EEQ%26sysparm_clear_stack%3Dtrue