Please try below code, tested it works as expected.
script:
(function executeRule(current, previous /*null when async*/) {
// Add your code here
var copyFrom = new GlideRecord(current.table_name);
copyFrom.get(current.table_sys_id);
var id = current.table_sys_id;
var copyTo = new GlideRecord('sc_task');
copyTo.addQuery('request_item',id);
copyTo.query();
if(copyTo.next()){
var task = copyTo.getUniqueValue();
}
copyAttachments(copyTo.getTableName(), task);
deleteDuplicateAttachments(task);
/************************** functions *****************************/
function copyAttachments(table, sys_id){
var attachmentUtil = new GlideSysAttachment();
attachmentUtil.copy(current.table_name, current.table_sys_id, table, sys_id);
}
function deleteDuplicateAttachments(sys_id){
var gr = new GlideRecord('sys_attachment');
gr.addQuery('table_sys_id', sys_id);
gr.orderBy('hash');
gr.orderBy('file_name');
gr.orderByDesc('sys_created_on');
gr.query();
var lastHash = 'not_a_match';
var lastFileName = 'not_a_match';
while(gr.next()){
var isDuplicate = false;
if ((lastHash == gr.hash) && (lastFileName == gr.file_name)){
isDuplicate = true;
}
if(isDuplicate)
gr.deleteRecord();
lastHash = gr.hash.getValue();
lastFileName = gr.file_name.getValue();
}
}
})(current, previous);
Hello,
Please try below the business rule to achieve your requirement.
Hope this helps!
If I have answered your question, please mark my response as correct and helpful.
thank you
Hi,
You could use GlideSysAttachment.copy('sourcetable','sys_id','destinationtable','sys_id'); in TASK activity if you are creating task via workflow
Copy attachments from record to record
GlideSysAttachment.copy('sc_req_item',current.sys_id,'sc_task',task.sys_id);
OR use flow designer instead of Business Rule
Regards,
JAS
