Scripting for Email Notification and approvals

[Pooja Khatri]

Hi All,

I have a requirement , where in a change request there are two fields : configuration item and assignment group
 also there is an approval on the change request form  it goes to approval first from the assignment group and second level to the CI assignment group approval .

Also in scenario if the assignment group and the configuration item assignment group members are same and if there are similar group members , if the change is first approved by any of the person in the assignment group .. the same person should not be allowed to approve the change at second level of approval which is CI assignment group level and also it should not trigger email notification to that person at the second level asking for approval and also in the related list in the approver tab it should show as "Not required" for the person in the second level of approval if that person has approved the change at first level of approval .

How can I implement this functionality , can anyone help me with the scripting here ?

[Omkar Kumbhar]

Hello @Pooja Khatri ,

First of all how the approval for the groups is getting triggered.

If it is getting triggered with the help of workflow, in the second approval i.e CI assignement group Please add the condition in script to check if the assignment group is same as CI assignement group, if it is same igonre the approval.

you can try the below code, Please debug it according

[Pooja Khatri]

Hi @Omkar Kumbhar - Yes it is getting triggered through workflow , but my requirement is - if the assignment group and ci assignment group approval is same , then only a single person who approved the change in the first level of approval ( which is assignment group approval ) only that person should not be allowed to approve the change in second level of approval (which is ci assignment group approval ) other person should be allowed to approve the request . How can I implement this functionality ?

[Omkar Kumbhar]

Hello @Pooja Khatri ,

Please try and debug the below code. I have not tested it. Do the changes according.

var members=  [];

var groupmember = new GlideRecord('sys_user_grmember');

groupmember.addQuery('group',current.ci_assignmentgroup);

groupmember.query();

while(groupmember.next());

{

members.push(groupmember.user.toString());    // get the members from the currnet groups

}

var approved_user= [];

//  check for the current change if the group has approved it

for (var i=0; i<=members.length ;i++);

{

    var approval_record= new GldieRecord('sysapproval_approver');

    approval_record.addQuery('source_table','change_request');

    approval_record.addQuery('state','approved');

    approval_record.addQuery('document_id', current.sys_id); // change record sys_id

     approval_record.addQuery('approver',members[i]);

approval_record.query();

while(approval_record.next())

{

    approved_user.push(approval_record.approver.toString());

}

}

// filter out the results by ignoring the approved user

var memeber_result = members.filter(approved_user);

[Omkar Kumbhar]

@Pooja Khatri you can also check this below link 

https://servicenowguru.com/scripting/business-rules-scripting/prevent-redundant-approval-requests-se...

Thank you,

Omkar