Copying Attachment from One field to another table.

Ubada Barmawar · ‎04-05-2024

Hi Experts,

I had a use case where I had to copy attachment from one table to another table so I used the script below.

var attachment = new GlideSysAttachment();

var attached = attachment.copy('source_table','source_table_sys_id', 'sys_data_source','datasource_sys_id' );

now that I have to copy an attachment from field on a custom table(file attachment type) to data source, the above script doesnt work as expected. the table name in sys_attachment appears as ZZ_YY appended by custom table name. Im not even able to copy field attachment to the same form.

any responses are highly appreciated

regards,

Ubada Barmawar

Sohail Khilji · ‎04-21-2024

Hi @Ubada Barmawar ,

What you have attempted is right yes need to created a business rule on change of attachment field you need to take the table name and sys_id of the attachment and copy it on target table using attachment.copy.

From the field which has attachement get the name of the file and do a glide record on sys_attachment table once the record attachment is found in query initialize the attachment on the target table were you needed it..

here is the sample code :

var gr = new GlideRecord('xxxx');
gr.get('f847adac1b40d110be52419fe54bcbca');
var fSys = gr.u_current_file.toString();
gs.info("File sys id: " + fSys);

var gAtach = new GlideRecord('sys_attachment');
gAtach.get(fSys);
gs.info("File Name:" + gAtach.file_name);

var targetRef = new GlideRecord('your_table');
targetRef.get('target_sys_id');

//Example of script

var glideSysAttachmentRef = new GlideSysAttachment();
var guid = "";
var newFileName = gAtach.getValue("file_name");

guid = glideSysAttachmentRef.writeContentStream(targetRef, newFileName, gAtach.getValue("content_type"), glideSysAttachmentRef.getContentStream(gAtach.getUniqueValue()));

View solution in original post

Mark Manders · ‎04-05-2024

Try the flow action 'copy attachment'. You can just give the source and the target and it will copy it for you.

Ubada Barmawar · ‎04-05-2024

copy attachment takes attachment from record and not from field.

Community Alums · ‎04-05-2024

.

Ubada Barmawar · ‎04-05-2024

This code is AI generated and it doesn't work!