Need help to copy attachment from Child case to Parent case

[VShine]

Hello Experts,

We have special use case where we have Parent & child case stored in same HR table. 

I need to copy attachment from child case (hr performance case table) to parent case (on HR performance case table).

I see multiple community posts where copy from one table to another. But I couldn't find help on copying attachment from one record to another on same table.

[rahulpandey]

Hi Vikrami,

Below example script(replace with your table and applicable sys_ids) will work on same table record too. 

GlideSysAttachment.copy('sn_hr_core_case_operations','sys_id','sn_hr_core_case_operations','sys_id');

Please mark answer correct, if it helps.

[VShine]

@rahulpandey Sys ID for the records will be different everytime. How can I get sys ID for parent & child case dynamically?

Also, shall I use this script as BR?

[rahulpandey]

Yes,

Use this in after BR. example  considering sn_hr_core_case_operations is table and parent column is column of parent.

GlideSysAttachment.copy('sn_hr_core_case_operations',current.sys_id.toString(),'sn_hr_core_case_operations',current.parent.sys_id.toString());

[Ankur Bawiskar]

@vikrami 

Parent HR details are stored in parent field so you can use this

To copy from child to parent

GlideSysAttachment.copy('performance table', current.sys_id, 'performance table', current.parent);

Regards
Ankur