Include only the last journal entry on a report

Nickels · ‎07-28-2016

I have a request to include either the last work note or last additional comment on a list report. I know how to include the last journal entry within notifications but I am not seeing a way to do this on a report. Any advice would be appreciated.

Thanks

-Chris

Chuck Tomasi · ‎08-05-2016

Thank you for the clarification. I was able to reproduce this (given some more sample data.)

The only way I can see that you can do this is to have a secondary u_comments (string) field and a business rule that maintains it. Something like

current.u_comments = current.comments.getJournalEntry(1);

This gets the latest entry and overwrites what ever is in the u_comments field. Use that on your report and you should be good.

View solution in original post

Pradeep Sharma · ‎07-28-2016

Hi Chris,

You may find below thread helpful.

Report on last additional comment

Chuck Tomasi · ‎07-28-2016

Hi Chris,

Simply adding the field to the list should do the trick.

mrswann · ‎08-04-2016

This doesn't restrict to the last comment, but pulls through all comments!

I ended up with a hundred pages report when I tried this!

Chuck Tomasi · ‎08-04-2016

Interesting, I've never seen it do that. What release of ServiceNow are you using?

Is this a standard table (e.g Incident)?