Only ITIL User should able to receive a CATALOG TASK email notification

[Jeck Manalo]

Hello Everyone,

I am trying to do some scripting in the email notification advance view. 

Where I want to achieve that only a ITIL member has able to receive the email when the catalog task is assigned to there group.

e.g the group is combination of IT people and HR. so what i want here is that only IT people can able to receive that notification.

Anyone knows how to achieve this ?

Here is the settings:

When to send:

Send when: record inserted or updated

Condition: assignment group changes or actual start changes and assigned to is empty

Who will receive:

Users/Group in field: assignment_group

Send to event creator: True

I added this code in advance view but non-itil member can still able to receive the email.

(function process(/* GlideRecord */ current, /* TemplatePrinter */ template, /* EmailOutbound */ email, /* EmailTemplate */ email_template, /* GlideRecord */ event) {

    var recipients = [];

    var gr = new GlideRecord('sys_user_grmember');

    gr.addQuery('group', current.assignment_group);

    gr.query();

    while (gr.next()) {

        var user = new GlideRecord('sys_user');

        user.get(gr.user);

        if (user.hasRole('itil')) {

            recipients.push(user.email);

        }

    }

    email.setRecipients(recipients.join(','));

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

[Ankur Bawiskar · Accepted solution]

@Jeck Manalo 

within email script you can't set the recipients.

Better use after update business rule on your table with proper conditions, event on your table and then trigger the notification via event using eventQueue()

I hope you can do that.

Ensure Event parm1 contains recipient = True in notification

BR script

    var recipients = [];
    var gr = new GlideRecord('sys_user_grmember');
    gr.addQuery('group', current.assignment_group);
    gr.addEncodedQuery("user.roles=itil");
    gr.query();
    while (gr.next()) {
        recipients.push(gr.user.toString());
    }
    gs.eventQueue('event_name', current, recipients.toString());

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

[Jeck Manalo]

thank you ankur its work perfectly.

[Sanjay191]

Hello @Jeck Manalo 

Please try the below logic 

(function process(/* GlideRecord */ current, /* TemplatePrinter */ template, /* EmailOutbound */ email, /* EmailTemplate */ email_template, /* GlideRecord */ event) {

 var recipients = [];

    var gruser = new GlideRecord('sys_user_grmember');

    gruser.addEncodedQuery("group="+current.assignment_group"^user.roles=itil");

    gruser.query();

    while (gruser.next()) {

            recipients.push(gruser.user.email);

    }

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


If you found this helpful, please give a thumbs up OR mark it as the solution. Thank you!

[Ankur Bawiskar]

@Sanjay191 

are you sure this script will work?