Not able to push the users into Approval User Workflow based on the condition

[Suvedha]

Hi all,

I have requirement, if approver and user and same, approval should not be triggered.

Script which has been written is not working. Could anyone help me out.

ar answer = [];

var user = current.variables.Requested_For;

var grpMem= new GlideRecord('sys_user_grmember');

grpMem.addQuery('group','965b95291bb4351426f45391604bcbf7');

grpMem.query();

while(grpMem.next())

{    

var approver = grpMem.getValue('user');

if(approver != user){   // to check requester!= approver //Not working

gs.log("inside" +approver);

answer.push(approver.toString()); // Not pushing the Approvers

}

else{

gs.log("else");

answer.push = '';

}

}

Thanks in advance.

Suvedha.

[Prashant Moily · Accepted solution]

Hi Suvedha,

Just try this below code and make sure you are using  "Approval User" activity 

var appAr = [];
var approvers = new GlideRecord('sys_user_grmember');
approvers.addQuery('group', current.assignment_group);
approvers.query();
while(approvers.next()) {
if(approvers.user.toString() != current.requested_by.toString()) {
workflow.info('APPROVER = ' + approvers.user.toString());
answer.push(approvers.user.toString());

}
}

answer = appAr;

Hope this information helps you.

[Prashant Moily · Accepted solution]

Hi Suvedha,

Just try this below code and make sure you are using  "Approval User" activity 

var appAr = [];
var approvers = new GlideRecord('sys_user_grmember');
approvers.addQuery('group', current.assignment_group);
approvers.query();
while(approvers.next()) {
if(approvers.user.toString() != current.requested_by.toString()) {
workflow.info('APPROVER = ' + approvers.user.toString());
answer.push(approvers.user.toString());

}
}

answer = appAr;

Hope this information helps you.

[Suvedha]

Hi Prashant,

Thanks for your response.

Approvals are generated now, but the if condition is not validating correctly.

Even if approver and requester are same, it going inside the if loop.

In the log it is satisfying with one of the group member.

Thank you,

Suvedha

[Vishal Birajdar · Accepted solution]

Hi @Suvedha 

You can exclude the requested for in through encodedQuery itself :

/* 1. Declare array */
var answer = [];
/* 2. get user from variable */
var user = current.variables.Requested_For;
/* 3. Glide record on group member table */

var grpMem= new GlideRecord('sys_user_grmember');
grpMem.addEncodedQuery('group=477a05d153013010b846ddeeff7b1225^user!= '+ user);  // this will exclude if requester for if its same 
grpMem.query();
while(grpMem.next())
{    
    var approver = grpMem.getValue('user');
     answer.push(approver.toString());
    
}

[Suvedha]

It worked!!

Thank you