Email Notification Subject

[snowuser111]

Hi I am creating a email template where the Subject line should be as below but I am not getting the Item name.

Table Sysapproval_approver

Service Request REQxxxxx for "Item name" has been Approved

Email Script for Subject:

_________________________________________________________________________________

email.setSubject("Service Request " + $(sysapproval) + " " +"for" + " " + req + "has been approved");  

  var gr = new GlideRecord("sc_req_item");

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

  gr.query();

while(gr.next())

{

  // template.print(gr.cat_item.getDisplayValue() + " ");

    var req = gr.cat_item.getDisplayValue();

    }

</mail script>

____________________________________________________________________________________

can anyone help where I am wrong in subject why isn't it retrieving the Item Name?

Thanks

[snowuser111]

Finally Worked.

Thanks a ton for all of you who spent time for helping and guiding me. String factor resolved the issue.All is I am learning a lot by the replied solutions. Community ROCKS !!!

Notification on table: request

Email Template on Table: sysapproval_approver

Final code as below:

____________________________________________________________________

var req = '';

var num = '';

var gr = new GlideRecord("sc_req_item");

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

gr.query();

if(gr.next())

{

      req = gr.cat_item.name.toString();

      num = gr.number.toString();

}

email.setSubject("Service Request " + num + " " +"for" + " " + req + "has been approved");

____________________________________________________________________

[snowuser111]

Just last one thing, what if I want to display the Request number instead of Item number ?

[Gurpreet07]

replace instruction       num = gr.number.toString();

with               num = gr.request.number.toString();

[snowuser111]

Ok. Thanks. I tested and below works perfect. Thanks Again

num = gr.request.number.toString();

[snowuser111]

Hi Gurpreet,

Is the notification for cancelled or rejected also be same like above?

Email notification Table: sc_request

Email template Table: sysapproval_approver

In that case also the above script should work? coz i created another two for cancelled and rejected but it was not retrieving the data in that case?