attachment from SC_task to REQ

[SAM321]

hi all actually i have task , when i upload any attachment in SC task form ,it should also been seen in REQUEST form related to that sc task. i tried below script but its not working .. can anyone tell whats wrong with below script , because am new to this scripting world

[jaheerhattiwale · Accepted solution]

@SAM321 Tried and Tested solution.

Please add when to run condition as below image

Add the below script:

var taskRec = new GlideRecord(current.table_name.toString());

taskRec.addQuery("sys_id", current.table_sys_id.toString());

taskRec.query();

if(taskRec.next()){

    GlideSysAttachment.copy(current.table_name.toString(), current.table_sys_id.toString(), "sc_request", taskRec.request.toString());

}

Please mark as correct answer if this solves your issue.

[jaheerhattiwale · Accepted solution]

@SAM321 Then keep the filter conditions same and change the script as below

var taskRec = new GlideRecord(current.table_name.toString());

taskRec.addQuery("sys_id", current.table_sys_id.toString());

taskRec.query();

if(taskRec.next()){

    GlideSysAttachment.copy(current.table_name.toString(), current.table_sys_id.toString(), "sc_req_item", taskRec.parent.toString());

}

Please mark as correct answer if this solves your issue.

[jaheerhattiwale]

@SAM321 Need the requirement then we can decide what to use. Like if we want to do this for existing records then we will go with scheduled job.

So need requirement.

[SAM321]

yes for existing records..how to do

[jaheerhattiwale · Accepted solution]

@SAM321 Create scheduled job

Go to "System Definition > Scheduled jobs" module

Click on new button

Click on "Automatically run a script of your choosing"

add below code and save

var scTask = new GlideRecord("sc_task");

scTask.addQuery("active=false");

scTask.query();

while(scTask.next()){

    GlideSysAttachment.copy("sc_task", scTask.sys_id.toString(), "sc_request", scTask.request.toString()); //This line for moving attachments to request

GlideSysAttachment.copy("sc_task", scTask.sys_id.toString(), "sc_req_item", scTask.parent.toString()); //This line for moving attachments to requested item

}

click on execute button

Please mark as correct answer if this solves your issue.

[SAM321]

great first one worked clearly thanks..@jaheerhattiwale what if it should be attached to sc_req_item.....its another task sir

[jaheerhattiwale]

@SAM321 Create one more business rule and just change the when to run filter condition as "Table Name is sc_req_item"

Keep the script as is.

Please mark as correct answer if this solves your issue.