Recipient list in notification script in email

ryadavalli · ‎07-07-2016

Can I get the list of recipients in a email notification script which I am using the email, before it is sent out. I know we can get if it is a field in the form, but from the

whom to fields?

Abhinay Erra · ‎07-18-2016

Ravali,

Here is your complete email script. I have tested this and it should work for you as well.

var userArr=[];

var count=0;

var fieldsArr1=email_action.recipient_users.toString().split(',');

var fieldsArr2=email_action.recipient_groups.toString().split(',');

var fieldsArr3 = email_action.recipient_fields.toString().split(',');

if(fieldsArr1)

   {

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

   userArr.push(fieldsArr1[i]);

   }

}

if(fieldsArr2)

   {

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

   var gr= new GlideRecord('sys_user_grmember');

   gr.addQuery('group',fieldsArr2[i]);

   gr.query();

   while(gr.next()){

   userArr.push(gr.getValue('user'));

   }

   }

}

if(fieldsArr3)

   {

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

   var inc_field = fieldsArr3[i].toString();

   userArr.push(current.getValue(inc_field));

   }

}

if(email_action.event_parm_1!='')

   {

   userArr.push(event.parm1);

}

if(email_action.event_parm_2!='')

   {

   userArr.push(event.parm2);

}

var arrayUtil = new ArrayUtil();

var gr1= new GlideRecord("sys_user_has_role");

gr1.addQuery('user','IN',arrayUtil.unique(userArr).toString());

gr1.addQuery('role.name','itil');

gr1.query();

if(gr1.getRowCount()==arrayUtil.unique(userArr).length){

   template.print("Click here to View: "+'${URI_REF}');

}

View solution in original post

ryadavalli · ‎07-19-2016

Yes Abhinay, I had to modify the logic a little bit the lines 43, as our system have multiple sys user roles records for same role.

Thanks a lot for your help

Abhinay Erra · ‎07-19-2016

Can you please mark it as correct. If you do not see a correct answer button, let me know.

ryadavalli · ‎07-19-2016

I did not see the correct button Abhinay. Could you please mark it correct

Abhinay Erra · ‎07-19-2016

Thanks for your feedback.I will let moderator know about this.

dan.bruhn can you please mark my response as correct.

Pradeep Sharma · ‎07-19-2016

Some users do not see the Correct Answer link (per this video at 20:00 https://community.servicenow.com/thread/224893). Let me know if you do not see it and I can get a community moderation to assist.