Pass user and manager name via gs.eventQueue

[Nikita Ms]

We have a requirement to sent email to requester's manager for certain tasks.

We have created a scheduled job for this.

How we can pass user name, manager name,  manager email address via scheduled job using gs.eventQueue() to the notification.

We have to send notification to requeter's manager and in notification we have to put requester's name and manager name.

[Anurag Tripathi]

You can add the field on notification body as

${u_client_id}

OR

${u_client_id.manager}

You can use dot walk to feel free to go to name or first name as neeed.

You can also choose the fields (and dot walk) from the right pane as below

[Nikita Ms]

Thank you, Anurag.

We are able to achieve expected functionality. Thank you for your help.

[Amit Gujarathi]

HI @Nikita Ms ,
I trust you are doing fine.

To send an email notification to a requester's manager for certain tasks, you can create a scheduled job that retrieves the necessary information and uses the gs.eventQueue() function to send the notification.

Here's an example code snippet to demonstrate how this can be achieved:

// Get the current user's record
var currentUser = gs.getUser();

// Get the requester's record for the current task
var requester = current.getValue('requested_for');

// Get the requester's manager's record
var manager = requester.manager;

// Get the email address of the manager
var managerEmail = manager.email;

// Get the names of the requester and the manager
var requesterName = requester.getDisplayValue();
var managerName = manager.getDisplayValue();

// Construct the email notification
var email = new GlideRecord('sys_email');
email.initialize();
email.addRecipient(managerEmail);
email.setSubject('Notification for task ' + current.number);
email.setBody('Dear ' + managerName + ',\n\nThis is to inform you that ' + requesterName + ' has requested a task that requires your approval.\n\nPlease take necessary actions.\n\nThank you,\nServiceNow');

// Queue the email notification for sending
gs.eventQueue('email.send', email, currentUser.getID(), 60);