Comma Separated Values in Email Script

[Poorva Bhawsar]

Hi Community,

I have this email script which is pulling affected products in the notification.

var gr = new GlideRecord("m2m_kb_ci");
gr.addQuery("kb_knowledge", current.sys_id);
gr.query();
while (gr.next()) {
template.print(gr.getDisplayValue('cmdb_ci'));
}

Currently its printing abcxyz. I want to have comma separated values as abc,xyz.

I tried to split it but nothing worked.

Kindly help me in this.

Thanks,

Poorva Bhawsar

[Kalyani Jangam1 · Accepted solution]

Hi @Poorva Bhawsar 

Please try below code, declare one array and push cmdb_ci value on that.

var arr=[];
var gr = new GlideRecord("m2m_kb_ci");
gr.addQuery("kb_knowledge",current.sys_id);
gr.query();
while(gr.next()) {
var num=gr.getDisplayValue('cmdb_ci');
arr.push(num);
}
template.print(arr);

Please check and Mark Helpful and Correct if it really helps you.

[Poorva Bhawsar]

Yes that worked for me... Thanks... 🙂

[Kalyani Jangam1]

Hi @Poorva Bhawsar 

That's Great!! Please mark Helpful also!!