Fetch last added additional comments/work notes into email notification

Harish74
Tera Expert

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)

 

1 ACCEPTED SOLUTION

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

Gunjan Kiratkar
Kilo Patron
Kilo Patron

Hi @Harish ,

 

From which context are you accessing work note/comment? You can try this out from a notification mail script or business rule

 

 

 

  var worknote = current.work_notes.getJournalEntry(1);

 

  var worknoteContent = worknote.split("(Work notes)\n");

 

  var lastWorknote = worknoteContent[1];

 

 

 

Thanks


Please Mark My Response as Correct/Helpful based on Impact
Regards,
Gunjan Kiratkar
2X ServiceNow MVP
Community Rising Star 2022
Youtube : ServiceNow Guy

Hi Gunjan,

 I have used what u mentioned in with email script. I'm getting the value as undefined.

var worknote = current.work_notes.getJournalEntry(1);

 

  var worknoteContent = worknote.split("(Work notes)\n");

 

  var lastWorknote = worknoteContent[1];

template.print(lastWorknote );

 

 

correct me if anything wrong in my script.

Hi Harish,

this should work fine

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

Hi Ankur,

It doesn't help me.

I have received nothing. (empty)