In a workflow, how to pull work notes from one catalog task to another?

[selenasmith]

I'm working on a (relatively) simple workflow which creates 2 catalog tasks:

1.   First task, send to support group manager for approval and comments in the "work notes" field.

2.   Second task to server admins for action

The second task needs to include the work notes from the first field.   What's a simple way to accomplish this?

Thanks,
Selena Smith

[selenasmith]

The only message in the systems log is "From workflow final return"

[Abhinay Erra]

Oh well then it not going into the while loop. Is your workflow on sc_req_item or sc_request table?

[selenasmith]

sc_request

[Abhinay Erra · Accepted solution]

Ahhh... See that is the problem, I was assuming this is on the sc_req_item all the way. Change your script to this, hopefully it will work now.

task.work_notes=pullComments();

function pullComments(){

  var comments=[];

  var gr= new GlideRecord("sc_task");

  gr.addQuery("request",current.getValue("sys_id"));

  gr.query();

  while(gr.next()){

  comments.push(gr.work_notes.getJournalEntry(-1));

  }

  return comments.join();

}

[selenasmith]

You're a genius!!!!!!!!!!!!!!!!!!!!!!!!!  

That worked!   Thanks for all your help and you patience with me!