Hi,
I am trying to copy attachments from ctask to change, I am able to do it but I am getting duplicates of previously attached attachments on change request level as I add any new attachment,
Here is the BR script:
(function executeRule(current, previous /*null when async*/) {
// Get the Change Task record associated with the attachment
var changeTaskGr = new GlideRecord('change_task');
if (changeTaskGr.get(current.table_sys_id)) {
// Get the parent Change Request Sys ID from the Change Task record
var changeRequestSysId = changeTaskGr.getValue('parent');
// Check if an attachment with the same name and file size already exists in the Change Request
var attachmentName = current.file_name.toString();
var attachmentSize = current.size_bytes.toString();
var targetAttachments = new GlideSysAttachment().getAttachments('change_request', changeRequestSysId);
var exists = false;
while (targetAttachments.next()) {
if (targetAttachments.file_name.toString() === attachmentName &&
targetAttachments.size_bytes.toString() === attachmentSize) {
exists = true;
break;
}
}
// Copy the attachment if it does not already exist
if (!exists) {
GlideSysAttachment.copy(current.table_name, current.table_sys_id, 'change_request', changeRequestSysId);
// Log the action for debugging purposes
gs.log('Copied attachment from change_task: ' + current.sys_id.toString() + ' to change_request: ' + changeRequestSysId);
} else {
gs.log('Attachment already exists in change_request: ' + changeRequestSysId);
}
}
})(current, previous);
