Include only the last journal entry on a report

[Nickels]

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

[mrswann]

Fuji Patch 12 Hot Fix 1

Yes - Incident. Do you think this needs a call to HI?

[mrswann]

I have also checked on Helsinki (PDI) and the same is true.

[Chuck Tomasi]

I'm still only seeing the last comment (Helsinki.) We're clearly doing something differently. Here's what I did:

1. Reports> View / Run
2. Create a list report on the incident table
3. Adding the Additional Comments field
4. Click Run

Share the steps you are doing to produce all additional comments please.

[mrswann]

When I hover the field:

When I export to PDF:

[Chuck Tomasi · Accepted solution]

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.