Copy a particular attachment to another record

Problem statement

We want to copy a particular attachment from a donor record to recipient record. ServiceNow GlideSysAttachment allows copying all attachments from one record to another using new GlideSysAttachment().copy() method, but we just want one of probably many attachments.

Possible solutions

• Copy all attachment and then delete ones that we do not need.
• Create a new script to implement exact requirements that we need.

We will choose the second option.

Solution

• We will create a new script includes in global scope since we need various methods only available in Global scope
• Whenever we need, we would call upon the call the class and the function as below

var donorAttachmentID, recipientTable, recipientID;
var utils = new global.CopyAtttachmentUtils();

// *******************************************************
// replace values as
// donorAttachmentID    : sys_id of attachment record
// recipientTable       : Table name of Recipient table
// recipientID          : sys_id of Recipient record 
// *******************************************************

utils.copySpecificAttachment(donorAttachmentID, recipientTable, recipientID);

Script Includes code

var CopyAtttachmentUtils = Class.create();
CopyAtttachmentUtils.prototype = {
    initialize: function() {
    },
	copySpecificAttachment : function (donorAttachmentID, recipientTable, recipientID) {
        var grNewAttachment;
        var attDataRecord;
        var newDocRecord;
        var grAttachment = new GlideRecord('sys_attachment');
        if (grAttachment.get(donorAttachmentID)) {
            grNewAttachment = this.copyRecord(grAttachment);
            grNewAttachment.setValue('table_name', recipientTable);
            grNewAttachment.setValue('table_sys_id', recipientID);
            grNewAttachment.update();
            attDataRecord = new GlideRecord('sys_attachment_doc');
            attDataRecord.addQuery('sys_attachment', donorAttachmentID);
            attDataRecord.query();
            while (attDataRecord.next()) {
                newDocRecord = this.copyRecord(attDataRecord);
                newDocRecord.setValue('sys_attachment', grNewAttachment.getValue('sys_id'));
                newDocRecord.update();
            }
        }
    },
    copyRecord: function (record) {
        var i,
            recordElement,
            recordElementName,
            recordTable = record.getTableName(),
            recordFields = record.getFields(),
            grNewRecord = new GlideRecord(recordTable);
        
        grNewRecord.initialize();
        
        for (i = 0; i < recordFields.size(); i++) {
            recordElement = recordFields.get(i);
            if(recordElement.getName() != 'sys_id' && recordElement.getName() != 'number')
            {
                recordElementName = recordElement.getName();
                grNewRecord.setValue(recordElementName, record.getValue(recordElementName));
            }
        }
        
        grNewRecord.insert();
        return grNewRecord;
    },

    type: 'CopyAtttachmentUtils'
};

That’s all folks.