I need to Copy an attachment from RITM to a Catalog Task

Allen12 · ‎02-09-2021

I need to copy an attachment from the Form or RITM to a Catalog Task. From what I have found online, this is what I have tried. However the attachment is not copying over to my Task. I usually work in Workflow Editor but was told this would be a better option. Any help is Appreciated.

Allen

Brad Bowman · ‎02-09-2021

I wouldn't say Flow Designer is a better option in this case, especially if you're more familiar with and already running a Workflow on the catalog item. If you must copy attachments, the easiest/best place to do this is in a Business Rule running on the sc_task table after Insert. All you need is this code in the Advanced Script.

(function executeRule(current, previous /*null when async*/) {

	GlideSysAttachment.copy('sc_req_item', current.request_item, 'sc_task', current.sys_id);

})(current, previous);

The reasons for not copying attachments are that it bloats the database with the same attachment record multiple times, and if the attachment is updated on the RITM or SCTASK, the other is not changed. A better option is to create a Defined Related List on the SCTASK form to show the attachments for the parent sc_req_item.

https://docs.servicenow.com/bundle/kingston-platform-user-interface/page/administer/form-administration/task/t_CreateDefinedRelatedLists.html

View solution in original post

Brad Bowman · ‎02-09-2021

I wouldn't say Flow Designer is a better option in this case, especially if you're more familiar with and already running a Workflow on the catalog item. If you must copy attachments, the easiest/best place to do this is in a Business Rule running on the sc_task table after Insert. All you need is this code in the Advanced Script.

(function executeRule(current, previous /*null when async*/) {

	GlideSysAttachment.copy('sc_req_item', current.request_item, 'sc_task', current.sys_id);

})(current, previous);

The reasons for not copying attachments are that it bloats the database with the same attachment record multiple times, and if the attachment is updated on the RITM or SCTASK, the other is not changed. A better option is to create a Defined Related List on the SCTASK form to show the attachments for the parent sc_req_item.

https://docs.servicenow.com/bundle/kingston-platform-user-interface/page/administer/form-administration/task/t_CreateDefinedRelatedLists.html

PranayR · ‎07-17-2023

Hi Brad,

As I'm new to ServiceNow, I have a doubt, An image in an RITM has uploaded by some 'X' person while requesting a catalog item however it demonstrates that it has been uploaded by some 'Y' person in an SCTASK related to the same RITM. how can I prevent this to happen?

Ian Mildon · ‎02-10-2021

What we did, to reduce duplication was to add a "flag" on the SCTASK to say that the Parent RITM has an attachment. That way it can be quickly viewed by use of the (i) lookup icon next to the Request Item field on the SCTASK.

Sebastian33 · ‎06-03-2021

Hello @Ian Mildon
Could you please elaborate on the "add a "flag" on the SCTASK to say that the Parent RITM has an attachment"?