Need to copy attachment from SCTASK to RITM table

[Dhanalakshmi D]

Hi,

I have a requirement of copying attachments from sctask to ritm table and below is the business rule I have tried but this added attachment thrice and even I need to avoid duplicate attachments.

Please someone could help!

Table - sys_attachment

 when to run - before, on insert and update.

var taskAtt = new GlideRecord('sc_task');
taskAtt.addQuery('sys_id', current.table_sys_id);
taskAtt.query();
if(taskAtt.next()){
var reqAtt = new GlideRecord('sc_req_item');
reqAtt.addQuery('sys_id',taskAtt.request_item);
reqAtt.query();
if(reqAtt.next()){

GlideSysAttachment.copy('sc_task', current.table_sys_id, 'sc_req_item', reqAtt.sys_id);
}
}

Thanks

[Dhanalakshmi D · Accepted solution]

Hi Gunjan,

This will delete existing attachment which is already present in RITM, which should not be where it should only copy the attachments from SCTASK.

Thanks

[Gunjan Kiratkar]

Hi @Dhanalakshmi D ,

You can delete existing attachment and copy the all attachment again as suggested in below post by Ankur.

Prevent duplicate attachments when copying 

[Gunjan Kiratkar]

Hi @Dhanalakshmi D ,

You can also copy latest attachment only by referring to the below thread code :- It will also eliminate duplicate's

Copy Newest Attachment Only From Task to RITM 

[Dhanalakshmi D]

Hi Gunjan,

This will delete existing attachment which is only in RITM which should not be.

Thanks

[Dhanalakshmi D · Accepted solution]

Hi Gunjan,

This will delete existing attachment which is already present in RITM, which should not be where it should only copy the attachments from SCTASK.

Thanks