How to capture last work note and comment in Business rule on Task?

[Kevin McGartlan]

Hello, 

I would like to capture the last work note or comment on a task. My business would like to use these fields for reporting purposes. I currently have a business rule setup to capture those fields by using the code below. This is an after Business Rule on update/insert: 

function executeRule(current, previous /*null when async*/) {

current.u_last_comment = current.comment.getJournalEntry(1);
current.u_last_work_note = current.work_notes.getJournalEntry(1);
//current.u_entered_by_comments = current.comments.

})(current, previous);

I'm not sure what's wrong here. The u_last_comment and u_last_work_note were both setup initially as Strings, but I changed them to Journal just in case there was a variable mismatch. Still no luck. Any ideas on what to do here?

Also, I wanted to see if I can grab the "Entered By" and "When" of the last work note/comment as well. Is there any functions I can use to get that data as well? 

Thank you!

[Allen Andreas]

Hi,

So is anything coming over at all?

Have you tried to do a gs.log(current.comment.getJournalEntry(1)); to see what it's saying?

Do you have any conditions listed that wouldn't make this run?

Is the BR actually active?

Have you tried to maybe do var lastComment = current.comment.getJournalEntry(1); and then do current.u_last_comment = lastComment; ?

Then entered by AND the date/time actually comes with it...which sort of sucks normally, but with your want, it should give you what you want. It'll be in the comment.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Kevin McGartlan]

I did try using gs.log on the two different fields, but it wasn't returning any values. Below is the log:

The BR is active. There are no conditions on when to run, except After and on insert and update. I also tried what you suggested here to switch the way I'm assigning variables. Still no luck. Any other ideas? I had thought maybe the business rule isn't activating, but it is as the log entries at least are executing. I had set the two fields to now be a String variable, but still no luck. 

That's great to hear about the entered by and Date/Time that comes with it. 

Thank you for your help!

[Kevin McGartlan]

Is there any sort of way to get that Entered By or When data though? We would like this data for reporting purposes again. 

[Harsh Vardhan]

var notes = current.work_notes.getJournalEntry(-1);    // -1 for all the work notes value , 1 for latest work notes value

var notes = current.comments.getJournalEntry(-1);   

i believe you missed "s"