Email Script for sending notification to requested for as CC

ServiceNow10sun
Giga Guru

Hi All , 

 

I need to send a notification to send to  requested for of RITM form  for which i am trying the below email script which is not working any suggestions. 

 

(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
          /* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
          /* Optional GlideRecord */ event) {

          var use= new GlideRecord('sys_user');
	
        var req = new GlideRecord('sc_req_item');
	req.addQuery("sys_id",current.sys_id);
	req.query();
    if (req.next()) 
	{ 
                                                  // Retrieve caller information
        var reqEmail = req.request.requested_for.email;
        var reqName = req.request.requested_for.name;

       
        email.addAddress("cc", reqEmail, reqName);// Add your code here

}})(current, template, email, email_action, event);
1 ACCEPTED SOLUTION

Sandeep Rajput
Tera Patron
Tera Patron

@ServiceNow10sun Could you please confirm if your notification is trigging on the request table or sc_req_item table?

 

If it is triggering on the sc_req_item table then you can update your script as follows.

 

(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
          /* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
          /* Optional GlideRecord */ event) {

          var use= new GlideRecord('sys_user');
	
        var req = new GlideRecord('sc_req_item');
	req.addQuery("sys_id",current.sys_id);
	req.query();
    if (req.next()) 
	{ 
                                                  // Retrieve caller information
        var reqEmail = req.request.requested_for.email +'';
        var reqName = req.request.requested_for.name +'';

       
        email.addAddress("cc", reqEmail, reqName);// Add your code here

}})(current, template, email, email_action, event);

View solution in original post

2 REPLIES 2

Sandeep Rajput
Tera Patron
Tera Patron

@ServiceNow10sun Could you please confirm if your notification is trigging on the request table or sc_req_item table?

 

If it is triggering on the sc_req_item table then you can update your script as follows.

 

(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
          /* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
          /* Optional GlideRecord */ event) {

          var use= new GlideRecord('sys_user');
	
        var req = new GlideRecord('sc_req_item');
	req.addQuery("sys_id",current.sys_id);
	req.query();
    if (req.next()) 
	{ 
                                                  // Retrieve caller information
        var reqEmail = req.request.requested_for.email +'';
        var reqName = req.request.requested_for.name +'';

       
        email.addAddress("cc", reqEmail, reqName);// Add your code here

}})(current, template, email, email_action, event);

it worked. Thank you.