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

selenasmith · ‎08-02-2016

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

Abhinay Erra · ‎08-03-2016

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();

}

Abhinay Erra · ‎08-02-2016

In the advanced script section of the second task activity, use this

task.work_notes=pullComments();

function pullComments(){

var comments=[];

var gr= new GlideRecord("sc_task");

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

gr.query();

while(gr,next()){

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

}

selenasmith · ‎08-02-2016

Thanks. I received an error message on the task -

org.mozilla.javascript.WrappedException: Wrapped ReferenceError: "next" is not defined

samuelscott · ‎10-18-2017

Hello Abihnay, I am dealing with a similar issue and can't seem to solve it. Could you help me out? Here the community post I created: https://community.servicenow.com/message/1269538?et=watches.email.thread#1269538

Piotr P · ‎08-18-2020

Hi,

Above script is working, but producing duplicate work notes, can you assist how to stop this

Thank you in advance

Piotr