best way to set recipients on a notification?

patricklatella · ‎01-10-2018

Hi gang,

I want to put together a notification that will send to users who are entered into a reference field on child tasks of a parent record.

Here's the scenario:

I have a custom table [x_cur_oc_feedback_oc_feedback] that has a [comments] field; this table is extended from task. Records in this table can have related child tasks. The child tasks have a custom field [business_contact] for assigning the task.

If the [comments] section on the parent record changes, I want a notification to be sent to the users entered in the [business_contact] field on the child tasks associated with the parent record (if there are any).

What's the best way to do this?

Should I write an email script to do a GlideRecord query to get the names in the [business_contact] field on the child tasks? How do I then set that list of names as the recipient of the email?

Or should I create an event that triggers a script action that queries and passes the names for the recipients of the email?

not sure which way to go...thanks!

ccajohnson · ‎01-11-2018

Based upon the recent suggestions,here is the script for the Business Rule:

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

// Query for existing child tasks and gather list of any actionees

       var gr = new GlideRecord('x_cur_oc_feedback_tasks');

       gr.addQuery('parent',current.sys_id);

       gr.query();

       var bcArray = [];//array of business contacts from child tasks

       while(gr.next()){

               if (gr.business_contact !=''){

                       if (bcArray.toString().indexOf(gr.business_contact) == -1){

                       bcArray.push(gr.business_contact.toString());

                       }

               }

       }

       gs.eventQueue('x_cur_oc_feedback.comments.added.notify',current,bcArray,'','');

})(current, previous);

View solution in original post

patricklatella · ‎01-10-2018

ok, so I think it's putting the array together correctly. it's grabbing the sys_ids of the business contacts. When these are passed as Parm1 to the notification for the "who to send to", the notification will be able to handle the recipients as sys_ids?

Michael Ritchie · ‎01-10-2018

Yes its expecting user SysIDs

patricklatella · ‎01-10-2018

just tried this script and am getting same error

patricklatella · ‎01-10-2018

OK great, thanks. so again I think it's building the array correctly, but it's throwing the event error. here's my current script:

Michael Ritchie · ‎01-10-2018

What is the scope of your business rule? That is a strange error.