Showing Request Item / Catalog Variables in Mail Script

wattsj · ‎10-23-2009

I'm using an email notification to send out information regarding approvals on RITM's. The information I want to send will contain the variable information from the item that was ordered.

I stole this script from another email notification:

template.print("Summary of Requested item:\n");
var gr = new GlideRecord("sc_req_item");
gr.addQuery("sys_id", current.sysapproval);
gr.query();
while(gr.next()) {
template.print(gr.number + ": " + gr.quantity + " X " + gr.cat_item.getDisplayValue() + "\n");
template.print(" Options:\n");
for (key in gr.variables) {
var v = gr.variables[key];
if(v.getGlideObject().getQuestion().getLabel() != '' && v.getDisplayValue() != '') {
template.space(4);
template.print(' ' + v.getGlideObject().getQuestion().getLabel() + " = " + v.getDisplayValue() + "\n");
}
}
}

My only issue is that the variables don't display in the proper order. You would think this would be an easy thing to accomplish, but I've been stuck for awhile. Any ideas?

wattsj · ‎02-04-2010

Yes, you can put a mail script right into the message. I have this setup on an approval request, here's the details:

table: sysapproval_approver
event: approval.inserted

and then I have a condition on the notification so that it only sends out for RITMs:

Approval for.Number "starts with" RITM

And finally here is my mail script inside the message of the email (this looks a little different than the one I posted, it helped me get the variables in order):



<mail_script>
  template.print("Summary of Requested item:\n"); 
  var gr = new GlideRecord("sc_req_item");
  gr.addQuery("sys_id", current.sysapproval);
  gr.query();
  while(gr.next()) {
template.print(gr.number + ":  " + gr.quantity + " X " + gr.cat_item.getDisplayValue() + "\n");
template.print("    Options:\n");

var varown = new GlideRecord('sc_item_option_mtom');
varown.addQuery("request_item", current.sysapproval);
varown.query();
while (varown.next()){
var visible = varown.sc_item_option.item_option_new.visible_summary;
var question = Packages.com.glideapp.questionset.Question.getQuestion(varown.sc_item_option.item_option_new);
question.setValue(varown.sc_item_option.value);
if (question.getLabel() != "" &amp;&amp; question.getDisplayValue() != "" &amp;&amp; visible == true){
template.space(4);
template.print('     ' +  question.getLabel() + " = " + question.getDisplayValue() + "\n");
}
}

  }
</mail_script>

View solution in original post

Aartz · ‎08-14-2013

Gotcha ! Awesome.. Thanks

martincohn · ‎02-20-2012

Thanks! Initial testing in Dev indicates that this has once again fixed the sort problem. Sorts based on the order number of the variables in the Catalog Item.

KristinaB · ‎03-19-2012

We have the same requirement whereas we want to list the variables in the approval email on RITMs. I'm not the best at reading code yet - still new at this. But does this code work for ALL your catalog items? Or do you need to customize it for every catalog item as they will contain different variables.

jim pisello · ‎01-23-2013

The code works for all items in your catalog which have variables. The code queries the table that stores the variables for your item and the values that were filled in for those variables when the item was ordered. No need to customize the code for each catalog item.

tmwrapelee · ‎07-17-2013

Does anyone know how to use this script and not with sysapproval? I tried it and it returned every sc variable in the email notification message. How do I adjust it for a sc task fulfillment email notification? Thank you in advance.
twl