How to pull "Requested Item Summary" field values of sysapproval_approver to notification body?

[sharsha]

How to pull all related field values of "Requested Item Summary"  of a sysapproval_approver record to a notification body using Email template in Servicenow?
Please see attached and advise if you've any idea!?

[vaishali231 · Accepted solution]

Hey @sharsha 

Try this :
Step 1: Create a Notification Email Script

Create a new Email Script (for example, RITM_Variable_Summary) 

code:

(function runMailScript(current, template, email, email_action, event) {

var ritm = current.sysapproval.getRefRecord();

if (!ritm || !ritm.isValidRecord())
return;

template.print("<h3>Requested Item Summary</h3>");
template.print("<table border='1' cellpadding='5' cellspacing='0' style='border-collapse:collapse;width:100%;'>");
template.print("<tr style='background:#f2f2f2;'>");
template.print("<th align='left'>Question</th>");
template.print("<th align='left'>Response</th>");
template.print("</tr>");

var variables = ritm.variables.getElements();

for (var i = 0; i < variables.length; i++) {

var variable = variables[i];

template.print("<tr>");
template.print("<td>" + variable.getQuestion().getLabel() + "</td>");
template.print("<td>" + variable.getDisplayValue() + "</td>");
template.print("</tr>");
}

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

})(current, template, email, email_action, event);

Step 2: Call the Mail Script in the Notification
In your Approval Notification (Table: sysapproval_approver), add the following to the Message HTML:
Requested Item Summary

${mail_script:RITM_Variable_Summary}

*********************************************************************************************************************************
If this response helps, please mark it as Accept as Solution and Helpful.
Doing so helps others in the community and encourages me to keep contributing.
Regards
Vaishali Singh
Servicenow Developer
Linkedin - https://www.linkedin.com/in/vaishali-singh-2273361bb

[Ankur Bawiskar · Accepted solution]

@sharsha 

You need to use email script in your email body and include it in email

Mail script: print_cat_item_request_submitted

Script

(function runMailScript(current, template, email, email_action, event) {

// Add your code here

template.print('Requested Item Summary: <br/>');

var ritm = new GlideRecord('sc_req_item');
ritm.get('request', current.sysapproval);

var variables = ritm.variables.getElements();
for (var i=0;i<variables.length;i++) {
var question = variables[i].getQuestion();
var label = question.getLabel();
var value = question.getDisplayValue();
if(label != '' && value !=''){
template.space(4);
template.print(' ' + label + " = " + value + "<br/>");
}
}

})(current, template, email, email_action, event);

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Danish Bhairag2]

Hi @sharsha ,

Is the requested item summary same as what the requestor has filled while submitting the form. If yes then it's pretty simple. You can do a Glide record query on sc_req_item table with filter as current.number(RITM number). Then u can access those variables like gr.variables.requestor. this way u can populate whatever u want in the notification body.

Thanks,

Danish Bhairagdar 

[sharsha]

Yes @Danish Bhairag2 , 'Requested item summary' is what the requestor has filled while submitting the catalog item form in the ESC portal. Could you please help me in detail please?

[Danish Bhairag2]

Hi @sharsha ,

Please refer the comments from either @Ankur Bawiskar / @vaishali231 that should help you.

Thanks,

Danish Bhairagdar

[sharsha]

Yes @Danish Bhairag2 ,  'Requested item summary' is what the requestor has filled while submitting the catalog item form in the ESC portal. Could you please help me in detail please, how to configure this with the help of notifications?