question Re: Copy currently inserted attachment in ITSM forum

Copy currently inserted attachment

Petr Pastuszek1 — Tue, 05 Mar 2024 07:52:50 GMT

Hello Team

When attachment is added to sc task we need to copy it to ritm.

but only currently inserted file/files,not those inserted yesterday and so on

any advice on script in BR on attachment table.

Re: Copy currently inserted attachment

Siddhesh Wani1 — Tue, 05 Mar 2024 08:07:12 GMT

Hi Petr,

There is one ServiceNow function for the copy attachment you can try this

'GlideSysAttachment.copy'

https://developer.servicenow.com/dev.do#!/reference/api/vancouver/server_legacy/GlideSysAttachmentGlobalAPI

To copy the only 1st attachment you can try with if loop, so it will take only 1st attachment.

If you find the solution useful Please mark this response as correct

Thanks and regard,

Siddhesh

Re: Copy currently inserted attachment

AniketC85155510 — Tue, 05 Mar 2024 08:09:38 GMT

Hello @Petr Pastuszek1 ,

Please give a try to the code below and see how it works for you,

(function executeRule(current, previous /*null when async*/) { // Get the current task record var taskRec = new GlideRecord('sc_task'); if (taskRec.get(current.table_sys_id)) { // Query for the most recent attachment with the current timestamp var attachment = new GlideRecord('sys_attachment'); attachment.addQuery('table_sys_id', current.table_sys_id); attachment.orderByDesc('sys_created_on'); attachment.setLimit(1); // Limit the result set to 1 record attachment.query(); if (attachment.next()) { // Get the associated RITM record var ritmRec = new GlideRecord('sc_req_item'); if (ritmRec.get(taskRec.request_item)) { // Copy the latest attachment to the RITM var gsa = new GlideSysAttachment(); gsa.writeContentStream( ritmRec, attachment.file_name, attachment.content_type, gsa.getContentStream(attachment.sys_id) ); } } } })(current, previous);

Please Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

Thanks & Regards,

Aniket.

Re: Copy currently inserted attachment

Anubhav24 — Tue, 05 Mar 2024 08:10:45 GMT

Hi @Petr Pastuszek1 ,

As already suggested by our colleagues to use GlideSysAttachment ,you can try that but if you have already tried something we would request you to paste the code you are trying to execute.

Please mark correct/helpful if my response helped you.

Re: Copy currently inserted attachment

Petr Pastuszek1 — Tue, 05 Mar 2024 08:33:49 GMT

Thank you!!!
I will give it try today in few hours,not at pc now.

user can insert 1 or more attachments at one time and those I need to duplicate to rirm always.

when I tried yesterday glidesysattachcopy function from ServiceNow,it always copy attachments uploaded in past whcih is not what we want. Only those files uploaded at current time.

/Petr

Re: Copy currently inserted attachment

AniketC85155510 — Tue, 05 Mar 2024 09:23:29 GMT

Hello @Petr Pastuszek1 ,

Okay then please give a try to the script below, which will allow you to copy multiple attachments for the current time

(function executeRule(current, previous /*null when async*/) { // Get the current task record var taskRec = new GlideRecord('sc_task'); if (taskRec.get(current.table_sys_id)) { // Query for attachments with the current timestamp var attachment = new GlideRecord('sys_attachment'); attachment.addQuery('table_sys_id', current.table_sys_id); attachment.addQuery('sys_created_on', '>=', gs.daysAgo(0)); // Attachments created today attachment.orderByDesc('sys_created_on'); attachment.query(); // Loop through the attachments while (attachment.next()) { // Get the associated RITM record var ritmRec = new GlideRecord('sc_req_item'); if (ritmRec.get(taskRec.request_item)) { // Copy each attachment to the RITM var gsa = new GlideSysAttachment(); gsa.writeContentStream( ritmRec, attachment.file_name, attachment.content_type, gsa.getContentStream(attachment.sys_id) ); } } } })(current, previous);

Re: Copy currently inserted attachment

Petr Pastuszek1 — Tue, 05 Mar 2024 12:26:10 GMT

Hello and thank you,

tested code and problem is that it control data created on today.

If I insert attachment 'A' now and 'B' 1 min later, end result is that RITM will have these attachments: A + B + B and this is not wanted.

is there really no way to copy only those which are currently inserted (current object) without need to query table?

/Petr

Re: Copy currently inserted attachment

Anubhav24 — Tue, 05 Mar 2024 15:27:17 GMT

Hi @Petr Pastuszek1 ,

Can you try this in a BR:

Table - Catalog Task
When to Run - Before Update
Scripts -
(function executeRule(current, previous /*null when async*/ ) {

// Add your code here
var copy = new GlideRecord('sc_req_item');
copy.get(<field name of RITM on sctask table>);
if (copy.next()) {
GlideSysAttachment.copy('sc_task', current.getUniqueValue(), 'sc_req_item', copy.getUniqueValue());
}
})(current, previous);

Please mark helpful/correct if my response helped you.

Re: Copy currently inserted attachment

Petr Pastuszek1 — Tue, 05 Mar 2024 15:42:07 GMT

Hello, the code doesnt work, I modified 'copy.get' part and doesnt work.

I was able today to figure out solution this way, could anyone confirm this is ok technically?

It is working really good and as expected, doesnt create duplicates ...

var grTask = new GlideRecord('sc_task'); grTask.get(current.table_sys_id); var grAttachment = new GlideRecord('sys_attachment'); grAttachment.initialize(); grAttachment.setValue('file_name',current.file_name); grAttachment.setValue('content_type',current.content_type); grAttachment.setValue('size_bytes',current.size_bytes); grAttachment.setValue('table_name','sc_req_item'); grAttachment.setValue('table_sys_id', grTask.request_item); grAttachment.insert();

/Petr

Re: Copy currently inserted attachment

Petr Pastuszek1 — Tue, 05 Mar 2024 15:43:28 GMT

This code which I have done is working well, could you confirm it is ok technically?

Re: Copy currently inserted attachment

Petr Pastuszek1 — Tue, 05 Mar 2024 15:56:37 GMT

Taking this back.

working well, but when its copied, its not usable. Its not real e.g. image object, when I download it to local disc, it doesnt open as it missing something from original file

Still trying to figure out next step.

Re: Copy currently inserted attachment

AniketC85155510 — Wed, 06 Mar 2024 07:30:54 GMT

Hello @Petr Pastuszek1 ,

Please try with the modified code below,

(function executeRule(current, previous /*null when async*/) { // Get the current task record var grTask = new GlideRecord('sc_task'); if (grTask.get(current.table_sys_id)) { // Create a new sys_attachment record var grAttachment = new GlideRecord('sys_attachment'); grAttachment.initialize(); // Set values for the new attachment record grAttachment.setValue('file_name', current.file_name); grAttachment.setValue('content_type', current.content_type); grAttachment.setValue('size_bytes', current.size_bytes); grAttachment.setValue('table_name', 'sc_req_item'); grAttachment.setValue('table_sys_id', grTask.request_item); // Insert the new attachment record var newAttachmentSysId = grAttachment.insert(); // Copy the content stream from the original attachment to the new attachment var gsa = new GlideSysAttachment(); gsa.writeContentStream( grAttachment, current.file_name, current.content_type, gsa.getContentStream(current.sys_id) ); // Optionally, log the new attachment sys_id for debugging gs.info('New Attachment Sys ID: ' + newAttachmentSysId); } })(current, previous);

Re: Copy currently inserted attachment

Petr Pastuszek1 — Wed, 06 Mar 2024 12:27:31 GMT

Thank you, I used your code and updated below way which is after many tests working really as expected.

It will copy always only currently uploaded attachment or attachments from ritm to sc_task. Thank you

/Petr

(function executeRule(current, previous /*null when async*/) { /****************************************************** * Access task into which attachment has been uploaded *****************************************************/ var grTask = new GlideRecord('sc_task'); if (grTask.get(current.table_sys_id)) { /****************************************************************** * Access RITM to which attachment will be copied from above task ******************************************************************/ var ritm = new GlideRecord('sc_req_item'); ritm.get(grTask.request_item); /******************************************************************************************* * Method to copy attachment from sc_task to RITM * Do not use other method because it will copy all attachments and not currently uploded *******************************************************************************************/ var targetGlideRecord = ritm; var fileName = current.file_name; var contentType = current.content_type; var sourceAttachmentSysId = current.sys_id; var gsa = new GlideSysAttachment(); gsa.writeContentStream( targetGlideRecord, fileName, contentType, gsa.getContentStream(current.sys_id) ); } })(current, previous);