Please help with email notification trigger.

[Erica2]

Hello,

When a change request is approved, I need to trigger a notification to both the "Created By" and "Opened By" users to let them the change has been approved.

I have set up the event registry, business rules, and notification, but the email is not being triggered. Could someone please take a look and suggest how to fix this?  Thank you

Registry:

Business Rule on Change Request Table:

Advanced Tab:

(function executeRule(current, previous /*null when async*/ ) {


    var gr = new GlideRecord('sysapproval_approver');
    gr.addQuery('sysapproval', current.sys_id);
    gr.addQuery('state', 'approved');
    gr.query();

    while (gr.next()) {
        gs.info('Start');
        gs.eventQueue('Change.approved.notification', current, gr.created_by, gr.openend_by, current);
        gs.info('End');
    }

})(current, previous);

Notification:

[Ankur Bawiskar · Accepted solution]

@Erica2 

created by and opened by will be same for CHG

So you will have to tweak it like this

(function executeRule(current, previous /*null when async*/ ) {

    var gr = new GlideRecord('sysapproval_approver');
    gr.addQuery('sysapproval', current.sys_id);
    gr.addQuery('state', 'approved');
    gr.query();
    while (gr.next()) {
        gs.info('Start');
        gs.eventQueue('Change.approved.notification', current, current.opened_by.toString(), '');
        gs.info('End');
    }

})(current, previous);

I hope your BR is configured correctly then it will work fine

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar · Accepted solution]

@Erica2 

so you are saying you want to send email to requested_by as well?

if yes then do this

(function executeRule(current, previous /*null when async*/ ) {

    var gr = new GlideRecord('sysapproval_approver');
    gr.addQuery('sysapproval', current.sys_id);
    gr.addQuery('state', 'approved');
    gr.query();
    while (gr.next()) {
        gs.info('Start');
        gs.eventQueue('Change.approved.notification', current, current.opened_by.toString() + ',' + current.requested_by.toString());
		//gs.eventQueue('Change.approved.notification', current, current.opened_by.toString(), '');
        gs.info('End');
    }

})(current, previous);

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Erica2]

You are extremely good at script @Ankur Bawiskar 

Thank you