question Re: SC_REQ_ITEM Approval Emails in ServiceNow AI Platform forum

SC_REQ_ITEM Approval Emails

rob_blakey — Tue, 11 Aug 2015 05:30:15 GMT

Hi Community,

I am struggling to get an approval email to include the options for the catalog request items.

I found: http://wiki.servicenow.com/?title=Scripting_for_Email_Notifications#Summary_of_Requested_Items

<mail_script>
template.print("Summary of Requested items:\n");   
var gr = new GlideRecord("sc_req_item");
gr.addQuery("request", current.sysapproval);
gr.query();
while(gr.next()) {
     var nicePrice = gr.price.toString();
     if (nicePrice != ) {
   nicePrice = parseFloat(nicePrice);
   nicePrice = nicePrice.toFixed(2);
     }
   template.print(gr.number + ": " + gr.quantity + " X " + gr.cat_item.getDisplayValue() + " at $" + nicePrice + " each \n");
   template.print(" Options:\n");
     for (key in gr.variables) {
     var v = gr.variables[key];
     if(v.getGlideObject().getQuestion().getLabel() != '') {
   template.space(4);
   template.print(' ' +   v.getGlideObject().getQuestion().getLabel() + " = " + v.getDisplayValue() + "\n");   
     }
     }
}
</mail_script>

However, when I try to acctually implement this it is not showing the options like it should

All I get in my email is:

Summary of Requested items:

And no options for my RITM tasks.

It should however look something like:

Summary of Requested item:

RITM0010114: 1 X XXXXXX Account at $0.00 each

Details of this request:

Requestor:

Employee's Name:

Job Title:

Contact Number (Ext.):

Store Number:

Line Manager: C

Please select role:

Nominated Printer:

Authorisation: Yes

Departments required:

Does anyone have any ideas of what is going wrong in my mail script?

Re: SC_REQ_ITEM Approval Emails

Tanaji Patil — Tue, 11 Aug 2015 05:47:45 GMT

I hope you are writing the above script without "<mail_script> </mail_script>" in a "Notification Email Script" and then calling it using "${mail_script:script name}" in your email body.

Create mail scripts in System Policy > Email > Notification Email Script starting with the Eureka release. Then add a ${mail_script:script name} embedded script tag to the body of the email notification or template, replacing script name with the name of the script you created.

Re: SC_REQ_ITEM Approval Emails

Tanaji Patil — Tue, 11 Aug 2015 05:53:44 GMT

Don't embed it directly into the Email Notification body. That won't work.

Re: SC_REQ_ITEM Approval Emails

rob_blakey — Tue, 11 Aug 2015 22:28:21 GMT

hi Tanaji,

Yes i am using a mail script i just copied the code as it was from the site to explain. But this still isn't working and pulling the values from the RITM

Re: SC_REQ_ITEM Approval Emails

gbernie — Wed, 12 Aug 2015 03:57:29 GMT

Hi Rob,

We did it slightly different and created a field called Order Details and then used the post from Jace to populate that field with all the details and in the correct order etc.

Jace Benson posted this and it is amazing. We use it for Catalog Approvals and to show the customer what they actually ordered without all the blank fields etc.

Show Catalog Variables as if they were on the form

Re: SC_REQ_ITEM Approval Emails

Michael Ritchie — Wed, 12 Aug 2015 21:14:28 GMT

Rob, I have this working in my instance. I basically cloned the code that worked with sc_requests and make it work with sc_req_items:

Created 3 new event registrations: reqitem.approval.inserted, reqitem.approval.rejected, reqitem.approval.cancelled
Edited the out of the box business rule called "Approval Events (Task)" that runs on the sysapproval_approver to create one of the above events for approvals on sc_req_item
Created 3 new email notifications that are called when the 3 above events are fired: Requested Item Approval Request, Requested Item Approval Rejected, Requested Item Approval Cancelled
Created email templates for each.

I assume you followed similar steps to mine. Below is the code for the template that gets called on new approval requests. I put this into the Email Template Message field, NOT HTML.

Short Description: ${sysapproval.short_description}


Priority: ${sysapproval.priority}


Requested For: ${sysapproval.request.requested_for}


Requested By: ${sysapproval.request.opened_by}


Total Price: ${sysapproval.request.price}


<hr/>


<mail_script>


   template.print("Summary of the Request:\n"); 


   var nicePrice = current.sysapproval.price.toString();


   if (nicePrice != '') {


           nicePrice = parseFloat(nicePrice);


           nicePrice = nicePrice.toFixed(2);


   }


   template.print(current.sysapproval.number + ":   " + current.sysapproval.quantity + " X " + current.sysapproval.cat_item.getDisplayValue() + " at $" + nicePrice + " each \n");


   template.print("       Options:\n");




   var keys = new Array();


   var set = new GlideappVariablePoolQuestionSet();     


   set.setRequestID(current.sysapproval);


   set.load();


   var vs = set.getFlatQuestions();


   for (var i=0; i < vs.size(); i++) {


       if(vs.get(i).getLabel() != '') {


           template.space(4);


           template.print('       ' +   vs.get(i).getLabel() + " = " + vs.get(i).getDisplayValue() + "\n"); 


       }


   }


</mail_script>


Comments:


${sysapproval.description}


<hr/>


${mailto:mailto.approval}


<hr/>


${mailto:mailto.rejection}


<hr/>


Click here to view Approval Request: ${URI}


Click here to view ${sysapproval.sys_class_name}:   ${sysapproval.URI}

Re: SC_REQ_ITEM Approval Emails

rob_blakey — Wed, 12 Aug 2015 21:52:42 GMT

Hi Michael,

Thank you so much! I am not too sure what is different between your code and mine however as soon as I turned your mailscript into a mailscipt it worked right away!

Re: SC_REQ_ITEM Approval Emails

Michael Ritchie — Wed, 12 Aug 2015 21:55:45 GMT

Awesome glad to hear my example code helped. I will admit my code was created prior to Fuji and mail scripts so I hadn't gone down that route yet.

Re: SC_REQ_ITEM Approval Emails

rob_blakey — Wed, 12 Aug 2015 22:08:15 GMT

Yeah, I am not used to mail scripts either, but apparently servicenow doesn't like you not using them in some instances so its just easier to create a mail script. But either way, it worked, and I am very thankful

Cheers

Re: SC_REQ_ITEM Approval Emails

pandyan1 — Thu, 13 Aug 2015 05:19:36 GMT

Hi Rob_blakey,

Create the Email template for Req_item table and use the below sample message format,

Short Description: ${short_description}

Click here to view item: ${URI_REF}

<hr/>

Severity: ${severity}

Priority: ${priority}

Category: ${category}

Comments:

${comments}

Re: SC_REQ_ITEM Approval Emails

jasonr — Thu, 20 Aug 2015 18:37:04 GMT

Hi Michael,

How could I revise your script to only pull one specific variable into an email rather than all of them?

Thanks,

Jason

Re: SC_REQ_ITEM Approval Emails

cwilkerbb — Thu, 20 Aug 2015 18:57:53 GMT

Jason,

To pull a specific field you should be able to just do it inline using something like Field Label: ${current.variables.my_field}

-Chris

Re: SC_REQ_ITEM Approval Emails

jasonr — Thu, 20 Aug 2015 19:08:44 GMT

It's a sysapproval email, and it wont pull like that unfortunately. I also tried ${sysapproval.current.variables.my_field}

Re: SC_REQ_ITEM Approval Emails

Michael Ritchie — Thu, 20 Aug 2015 19:12:08 GMT

Try: ${sysapproval.variables.my_field}

Re: SC_REQ_ITEM Approval Emails

jasonr — Thu, 20 Aug 2015 19:16:14 GMT

Wow I feel silly. Thanks Michael. You're my hero for the day.

Re: SC_REQ_ITEM Approval Emails

Michael Ritchie — Thu, 20 Aug 2015 19:19:51 GMT

No worries. Just to confirm variables in the script:

current = sysapproval_approval record

sysapproval = task record requiring approvals

If the record requiring approval is NOT a task, then there are document ID fields that store the table and SysID of the record requiring approval.

With using ${sysapproval.XXX} you can dot walk to anything from the task table.