How to show worknotes added by in email notification

[Talari Balateja]

Hi,

I want show case worknotes in the notification along with "worknotes added by".

I got stucked in worknotes added by.

Table _incident

Regards,

Sanju

[Sohail Khilji]

Hi @Talari Balateja 

Create a mail script and call it on your notification.

var rec = new GlideRecord('sys_journal_field');
rec.orderByDesc('sys_created_on');
rec.addQuery('name', current.getTableName());
rec.addQuery('element', 'work_notes');
rec.addQuery('element_id', current.sys_id);
rec.setLimit(1);
rec.query();
if(rec.next()){

template.print(rec.value);

}

[Talari Balateja]

Hi @Sohail Khilji 

I want show highlighted name in notification

[Sohail Khilji]

Hi @Talari Balateja 

try :

var rec = new GlideRecord('sys_journal_field');
rec.orderByDesc('sys_created_on');
rec.addQuery('name', current.getTableName());
rec.addQuery('element', 'work_notes');
rec.addQuery('element_id', current.sys_id);
rec.setLimit(1);
rec.query();
if(rec.next()){

var wrk_nts = rec.value.toString();
wrk_nts.split(' ');
var value = wrk_nts[0];

template.print(value); // this will print only the first work from the string

}

[Talari Balateja]

Hi @Sohail Khilji 

It's showing worknotes not the added by 

like I want show comments added by "manjrekar"