Event Parameters Mail Script

Ken83 · ‎12-05-2014

Hello Community,

I'm using an event to trigger an email notification. I'm calling this event from within a workflow Run Script activity. I have pulled values in the workflow and written them to the workflow scratchpad. In the Run Script activity, I have created variables containing the scratchpad values. The 2 values are sys_ids for users. When I pass these values into the event, I need to then use them in a mail_script and I currently cannot do that. Is this even possible?

I read this and it looks like this would work, except it doesn't...

The event parameters are

Brad Tilton · ‎12-05-2014

Your second option is the correct syntax.

Just to be clear, does the parameter contain just the user's sys_id or does it contain 'User sys_id'? What happens when you add the following logging in?

var userID = event.parm1; //this should be just a sys_id


gs.log('---->User ID from event.parm1: ' + userID);


var gr2 = new GlideRecord('sysapproval_approver');


gr2.addQuery('approver', userID);


gr2.addQuery('state', 'requested');


gr2.query();


gs.log('---->Number of rows returned: ' + gr2.getRowCount());


while(gr2.next()){


   gs.log('---->Approval for: ' + gr2.sysapproval.getDisplayValue());


}

View solution in original post

Ken83 · ‎12-05-2014

Looks like I had to create a variable for the event.parm1 value. It works when I do that. Thanks for the help!