How to loop through variables in a variable set for Email Script

Matt Cordero1 · ‎05-20-2019

I am trying to read in values from a Service Catalog request and will email the general request information when the request is complete. Part of the request is using a Variable Set with 5 fields (1 plain text, 4 reference).

Here is the code I have so far. I just can't figure out how to read in the values from the Variable Set (looping through the result set itself). I can read in values from the Variable pool just fine.

var gr = new GlideRecord("sc_req_item");
gr.addQuery("sys_id", current.sys_id);
gr.query();
while(gr.next()) {
var requestedBy = gr.variable_pool.requested_by.getDisplayValue();
var whoIsThisFor = gr.variable_pool.who_is_this_for_ref.getDisplayValue();
var forSelect = gr.variable_pool.requesting_for_select.getDisplayValue();
var contactNumber = gr.variable_pool.contact_number.getDisplayValue();
var reqHTML = gr.variable_pool.image;
var blacklineReconciliation = gr.variable_pool.blackline_reconciliation_reassignment_request;

template.print("Requested By: " + requestedBy + "\n");
if (forSelect == 'Someone Else')
template.print("Requested For: " + whoIsThisFor + "\n");

template.print(" Contact Number: " + contactNumber + "\n");
template.print(" Blackline Reconciliation Reassignment:\n");

if(reqHTML)
template.print(" Additional Comments/Images:" + reqHTML);

template.print("<hr />");
}

Matt Cordero1 · ‎05-21-2019

Here is the code block that I used to be able to loop through a Variable Set:

blackline_reconciliation_reassignment_request is the internal name of the Variable Set. For the acct/group name, I am able to extract the sting entered easily. For the other 4 reference fields, I am given a sys_id, so I need to reference back to the sys_user table to get the user's name.

//Blackline Reconciliation Reassignment information
template.print(" Blackline Reconciliation Reassignment:\n");
template.print("<table width='100%' border='1'>");
template.print("<tr style='background-color:lightgrey'>");
template.print("<th>");
template.print("Reconciliation (Acct Number/Group Name)");
template.print("</th>");
template.print("<th>");
template.print("Old Preparer");
template.print("</th>");
template.print("<th>");
template.print("Old Approver");
template.print("</th>");
template.print("<th>");
template.print("New Preparer");
template.print("</th>");
template.print("<th>");
template.print("New Approver");
template.print("</th>");
template.print("</tr>");

template.print("</table>");

Rendering comes up very quickly and previews well in an email template. If there are any improvements that can be made, please reply here. If you were able to use this code or find it useful, please mark the post helpful. 😃

View solution in original post

Prateek kumar · ‎05-20-2019

Did you check this?

https://community.servicenow.com/community?id=community_question&sys_id=31b447e9dbd8dbc01dcaf3231f9619b1

and on which table your email is configured on??

Please mark my response as correct and helpful if it helped solved your question.
-Thanks

Matt Cordero1 · ‎05-21-2019

Yes, I saw the article and that's not helping. I am able to get the values I need from the variables. I am unable to get the values I need from the variable set. Since the user is going to be able to add multiple items to the request, I need to loop through them to get all the information that the user enters.

This is the variable set (blackline_reconciliation_reassignment_request), with variable names for each of the items:

How do I loop through the variable set (from the GlideRecord) to read all the values for display???

Jagadeesh R1 · ‎05-21-2019

Hello,

Did you tried to glide through variables instead of variable pool.

Suppose in the script instead of gr.variable_pool try using gr.variables.<variable name>. I am not sure whether this will be helpful but please give it a try

Regards,

Jagadeesh

Johnnie O_ · ‎05-21-2019

try using GlideappVariablePoolQuestionSet

var set = new GlideappVariablePoolQuestionSet();
set.setRequestID(gr.sys_id);
set.load();
var vs = set.getFlatQuestions();

for (var i=0; i < vs.size(); i++) {
  if(vs.get(i).getLabel() != '' && vs.get(i).getDisplayValue() != '') {
    template.print('<tr><th> '+ vs.get(i).getLabel() + '</th><td>' + 
    vs.get(i).getDisplayValue() + '</td></tr>');
  }
}

In this example I have some formatting in here for populating the information into an HTML table so you will need to remove the table tags or add the missing tags to your script.