Adding cat item variables to email notification

matthew_magee1 · ‎07-21-2014

Hi all,

I think I'm trying to do something pretty simple.

I have a few variables on my catalog item form that I need to pull into an email notification. One of the fields being 'alt_poc_phone'

I've tried GlideRecord and current.variable_pool.alt_poc_phone and neither seems to work.

I've also referenced the following wiki page (Scripting for Email Notifications - ServiceNow Wiki), but something's not clicking (on my part).

Any help is greatly appreciated (with examples)

MM

matthew_magee1 · ‎07-24-2014

Mandar/Adam-

Follow up to my post. For some reason the mail script is working now. I'm not sure why it wasnt' working earlier. I guess I had a typo or something.

Here's the script that works:

<mail_script>

var item = new GlideRecord("sc_req_item");

item.addQuery("request", current.sys_id);

item.query();

while(item.next()) {

var catalogItem = item.number + ': ' + item.cat_item.getDisplayValue();

var misc = item.variable_pool.alt_poc;

template.print(catalogItem + "<br/> Field: " + misc);

}

</mail_script>

Really appreciate the feedback guys, couldn't have done this without you-

On to my next challenge

matthew_magee1 · ‎02-11-2017

Hey Chris,

Post your code and I'll give it a once-over to see what's going on-

Matthew

Chris150 · ‎02-13-2017

Hey Matthew,

Thanks for the response and thank you for this post to get me started, I was able to figure it out.

Your first two lines had...

<mail_script>

var item = new GlideRecord("sc_req_item");

item.addQuery("request", current.sys_id);

Mine needed to be...

var item = new GlideRecord("sc_req_item");

item.addQuery("sys_id", current.sys_id);

I also modified the final print line to add labels for each field value.