Fetch last added additional comments/work notes into email notification

Go to solution
Harish74
Tera Expert

‎02-15-2021 02:03 AM

Hi there,

I need to fetch recent additional comments/work notes into email notification. i have used current.comments.getJournalEntry(1) & current.work_notes.getJournalEntry(1) to achieve this. But I'm getting the time frame as well with the additional comments. Can I able to fetch only the comment/work notes ??

Eg: Work notes: This is a test work notes (I required)

Work notes: 2021-02-15 01:22:40 AM PST - User Name (Work notes) This is a test work notes (I don't required)

 

Labels:
0 Helpfuls
  • 3,201 Views
1 ACCEPTED SOLUTION

Go to solution
Ankur Bawiskar
Tera Patron
Tera Patron
In response to Harish74

‎02-15-2021 02:35 AM

Hi,

try this

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

}

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

10 REPLIES 10

Go to solution
Ankur Bawiskar
Tera Patron
Tera Patron

‎02-15-2021 02:15 AM

Hi,

you can use this to get only the value

current.work_notes.getJournalEntry(1).match(/\n.*/gm).join("\n");

Reference:

Remove User info and timestamp from commets

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader