Email Notification Request Number and all its RITM

[Fredo1]

I want to send an email with a summary with the Request Number and all the RITM's

I have the following script

template.print('<p>' + 'Click here to view request: ' + '${request.URI_REF}');

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

template.print("Summary of Requested items:");

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

var gr = new GlideRecord("sc_req_item");

//gr.addQuery("request", current.sys_id);

gr.addQuery("sys_id", current.sysapproval);

gr.query();

while(gr.next()) {

      }

      template.print(gr.number + ":   " + gr.cat_item.getDisplayValue());

}

But, I only get this

Click here to view request: REQ0010312

Summary of Requested items:

undefined: undefined

Can you let me know what I have wrong?

Many thanks in advance...

[Fredo1]

No go...

Only prints one of three...

[BALAJI40 · Accepted solution]

Please check now, above code contains brackets closed between while and template. Now copy paste the exact code and check the results and please let me know.

template.print('<p>' + 'Click here to view request: ' + '${request.URI_REF}');

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

template.print("Summary of Requested items:");

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

var gr = new GlideRecord("sc_req_item");

gr.addQuery('request',current.request);

gr.query();

while(gr.next()) {

//}   remove this line, because of this it prints one record only.

      template.print(gr.number + ":   " + gr.cat_item.name);

}

[Fredo1]

BINGO....

It shows all three but now, how can I get hyperlinks for the RITMs? any ideas?

and many thanks for helping me out so much

[BALAJI40]

Very happy that, your issue was resolved. Hyperlinks not sure but try this and check once,

template.print('<p>' + 'Click here to view request: ' + '${request.URI_REF}');

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

template.print("Summary of Requested items:");

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

var gr = new GlideRecord("sc_req_item");

gr.addQuery('request',current.request);

gr.query();

while(gr.next()) {

      template.print(${URI_REF} + ":   " + gr.cat_item.name);

}

[SC10]

On your second to last line, the template.print, would this not print out the URI_REF of the REQ still? How would you instead print out a URI_REF to applicable RITM?