- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
Solved! Go to Solution.
- Labels:
-
Demand Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-15-2021 02:06 AM
Hi
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-15-2021 02:18 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-15-2021 02:22 AM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-15-2021 02:28 AM
Hi Ankur,
It doesn't help me.
I have received nothing. (empty)