How to access a catalog item variable in a notifications "Who will receive" section?

[Jared Wason]

Hi there, I have a catalog item users fill out that has a Requested_for, Opened_by, and u_who_gets_data_access field. I have no problem accessing the Requested_for or Opened_by in a Notification for "Who will receive" tab, but I can't seem to access that u_who_gets_data_access variable. I can access that variable in the "What it will contain" tab via ${parent.variables.u_who_gets_data_access}. Is there a way for me to get that variable into the "Who will receive" tab, or a different way of going about this process in general? I tried looking on the sc_req_item and sc_request tables to see if there was a unused user field that I could take advantage of but with no success.Any ideas are appreciated, thanks!

[Chaitanya Redd5]

Hi Jared,

You can add the cc or bcc in the email using email script. Please find the sample code below:

(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */ event) {
	
	// Add your code here
	email.addAddress("cc", "user@example.com","User");
	email.addAddress("bcc", "user@example.com","User");
})(current, template, email, email_action, event);
//replace usr@example.com with the recipient email address
//replace User with the Display name of user.
//you can get the variable details from variables using current.variables.variable_name

Kindly mark my answer as Correct and Helpful based on the Impact.

Regards,

Chaitanya

[Michael Jones -]

There really isn't a way to do this, with a "normal" notification that I'm aware of. The only way I can see this working would be to make your notification event driven instead, so that you could call the notification (either from a Business Rule or from a Workflow) and dynamically pass the users you want as recipients. 

This document outlines how to create an event and a notification: 

https://docs.servicenow.com/bundle/newyork-servicenow-platform/page/administer/notification/task/t_C...

On the notification you would need to be in the advanced view (might have to save the record before you can change the view) and would want to set the field "Event parm 1 contains recipient"

Once you have your event and your notification created, you can invoke it within a server-side script using

gs.eventQueue(<eventname>, current, <param1>);

For param1 you can pass a comma separated string of either email addresses, or sys_ids or users. 

If this was helpful or correct, please remember to be kind and click appropriately!

[Jared Wason · Accepted solution]

I ended up find the solution to my needs by adding the third variable "u_who_gets_data_access" to the watch_list field. This allowed me to then put the request.watch_list in the email notification.