How to print approval Rejected person name on email body

Nani18
Tera Contributor

‎01-31-2024 04:34 AM - edited ‎01-31-2024 04:35 AM

Hello Experts,

I am trying to print current RITM approval rejected person name in email notification with rejected comments .

but the below script is not working

 

Please correct the script :

 

(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
    /* Optional EmailOutbound */
    email, /* Optional GlideRecord */ email_action,
    /* Optional GlideRecord */
    event) {
    var notes;
var grRITM = new GlideRecord("sc_req_item");
    grRITM.addQuery('sys_id', current.request_item);
    grRITM.query();
    while (grRITM.next()) {
    
    var appr = new GlideRecord('sysapproval_approver');
    appr.addQuery('document_id', grRITM);
    appr.addQuery('state', 'rejected');
    appr.query();
 
    while (appr.next()) {
        var je = new GlideRecord('sys_journal_field');
        je.addQuery('element_id', appr.sys_id);
        je.addQuery('elements', 'comments');
        je.addQuery('name', 'sysapproval_approver');
        je.query();
        if (je.next()) {
            notes = je.value;
        }
 
        template.print('<p>Rejected by: ' + appr.approver.getDisplayValue() + '</p>');
        template.print('<p>Comments: ' + notes + '</p>');
        
    }
}
})(current, template, email, email_action, event);

 

 

Best Regards,

Nani

0 Helpfuls
  • 308 Views
1 REPLY 1

Aniket Chavan
Tera Sage
Tera Sage

‎01-31-2024 06:46 AM

Hello @Nani18 ,

 

Please give a try to the code below and see how it works for you.

(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
    /* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
    /* Optional GlideRecord */ event) {
    var notes;
    var grRITM = new GlideRecord("sc_req_item");
    grRITM.addQuery('sys_id', current.request_item);
    grRITM.query();
    while (grRITM.next()) {
        var appr = new GlideRecord('sysapproval_approver');
        appr.addQuery('document_id', grRITM.sys_id);
        appr.addQuery('state', 'rejected');
        appr.query();

        while (appr.next()) {
            var je = new GlideRecord('sys_journal_field');
            je.addQuery('element_id', appr.sys_id);
            je.addQuery('element', 'comments');
            je.query();
            if (je.next()) {
                notes = je.value;
            }

            template.print('<p>Rejected by: ' + appr.approver.getDisplayValue() + '</p>');
            template.print('<p>Comments: ' + notes + '</p>');
        }
    }
})(current, template, email, email_action, event);

 

Let me know your views on this and Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

 

Thanks,

Aniket

0 Helpfuls