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

mrswann · ‎08-05-2016

I cannot mark as correct as it is not my question! But it is correct for me!

Good work Chuck thanks again

Chuck Tomasi · ‎08-05-2016

Thanks mrswann. Sorry for the issues with the community SW.

dan.bruhn assistance required.

sindhu11 · ‎07-14-2020

@Chuck Tomasi

Hi chuck,

As per your instructions I have created last comments field and created before business rule to run.

But while exporting the report to PDF I can see at what time the worknotes is updated and who has updated but here I want to know what was the last comments that user has been updated.

Here is my last comment "testing notification".

What I see in PDF is.

Could you please help me the worknotes data?

Chuck Tomasi · ‎07-15-2020

Are you asking how to remove the date and person and see ONLY latest comments?