question Re: How to get the last comment in Developer forum

How to get the last comment

SNOW39 — Tue, 09 Jul 2019 09:00:47 GMT

we are sending a notification when the RITM is complete. The body should have the last comment in the body without timestamp.

How can i achieve this?

Re: How to get the last comment

David Stutter — Tue, 09 Jul 2019 09:03:57 GMT

https://developer.servicenow.com/app.do#!/api_doc?v=london&id=SGE-getJournalEntry_N

oh without timestamp, it is sad that service now does not provide this feature without timestamps.

We removed the annoying part with regex.

Re: How to get the last comment

Omkar Mone — Tue, 09 Jul 2019 09:07:12 GMT

You can try something like this :-

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

var onlyNotes = worknotes.split("(Work notes)\n");

var lastWorknote = onlyNotes [1];

Re: How to get the last comment

Harish KM — Tue, 09 Jul 2019 09:12:53 GMT

can try this

var wn1 = target.work_notes.getJournalEntry(1);
var wn2 = wn1.split("(Work notes)");
wn2.splice(0,1);
var work_notes = ' Work Notes: ' + wn2;

Re: How to get the last comment

SaiRaviKiran Ak — Tue, 09 Jul 2019 09:15:49 GMT

Below links could help you out :

https://community.servicenow.com/community?id=community_question&sys_id=65a403e9dbd8dbc01dcaf3231f9619a5

https://community.servicenow.com/community?id=community_question&sys_id=6a1a0b69db5cdbc01dcaf3231f96198d

Thanks,

Ravi

Re: How to get the last comment

SNOW39 — Wed, 10 Jul 2019 09:57:44 GMT

tried this.. not working

Re: How to get the last comment

Manish Vinayak1 — Wed, 10 Jul 2019 11:06:36 GMT

The solution suggested by Omkar and others should work if the field name is work_notes and the label is "Work Notes". Just wanted to check are you trying to retrieve the last work notes added or the last additional comments added to the RITM? If it is additional comments, you will need to tweak the code accordingly.

Also, I am assuming you already have the email script to get the comments printed in your email notification; would you be able to share the code written in the email script? That would help people to suggest you changes.

Thanks,

Manish