Email Notification Subject

snowuser111 · ‎05-21-2015

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

Kalaiarasan Pus · ‎05-21-2015

Not sure what exactly you are looking for but try the below and use the subject you want ...

var requestNumber = '';
var catalogName = '';
var ritmNumber = '';
var gr = new GlideRecord("sc_req_item");
gr.addQuery("sys_id", current.sysapproval);
gr.query();
if(gr.next())
{
catalogName = gr.cat_item.name.toString();
requestNumber = gr.request.number.toString();
ritmNumber = gr.number.toString();
}

email.setSubject("Service Request " + requestNumber + " " +"for" + " " + catalogName + " has been approved");
//email.setSubject("Service Request " + ritmNumber + " " +"for" + " " + catalogName + " has been approved");

</mail script>

Note : The template must be running on sysapproval_approver

View solution in original post

Gurpreet07 · ‎05-21-2015

Place setSubject line below your logic to get req. and check

snowuser111 · ‎05-21-2015

But the line itself is email.setSubject (.......................). Separately do I need to again do that

Gurpreet07 · ‎05-21-2015

I just mean to say change its position . like below code

<mail_script>

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();

}

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

</mail script>

Anurag Tripathi · ‎05-21-2015

try using ${sysapproval.number} instead

-Anurag