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...

[BALAJI40]

try with this 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('sys_id',current.sys_id); replace this line with previous

gr.query();

while(gr.next()) {

      }

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

}

[Fredo1]

Getting close

I just got one request item displayed out of 3 that I submitted

Any more ideas and thanks

[BALAJI40]

Try this one and 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);

while(gr.next()) {

      }

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

}

[Fredo1]

It displayed only one requested item and this time the middle one...

[BALAJI40]

sorry you want RITMs right, so you need to query from sc_request table. Try this one definitly you can achieve your answer.

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_request");

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

while(gr.next()) {

      }

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

}