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 No, use it as it. It should work

[SAM321]

@jaheerhattiwale sir how to achieve this on another way.  means without using sys_attachment table

[jaheerhattiwale]

@SAM321 From where you want to trigger it? 

[SAM321]

i submitted the task ...but they repiled "if u not have access to sys_attachment table . how can u achieve it!"... try to do in another way.

[jaheerhattiwale]

@SAM321 Access to "sys_attachemnt" table is not required. Ask them to try with the end user. It should work.

End user should not go and the record in "sys_attachemnt" table, it will be done by system and system will triggers the Business Rule on attachment table.