Hello,
I have a lot attachment on sys_attachment that I would copy on different KB Articles.
I made an On after script on my Transform who import the articles. But it doesn't work.
When I tried between two articles from kb_knowledge, it's works fine.
Do you have any ideas ? I already copy from sys_attachment to another table, but this time, it doesn't works..
Thanks
// log.info("source.u_attachment = " + source.u_attachment);
// GlideSysAttachment.copy('sourcetable', 'sys_id', 'destinationtable', 'sys_id');
var sysAttachment = new GlideRecord('sys_attachment');
sysAttachment.addQuery('file_name',source.u_attachment);
sysAttachment.query();
if(sysAttachment.next()){
log.info("copy attachment " + sysAttachment.sys_id + " on knowledge article " + target.number + " - " + target.sys_id);
GlideSysAttachment.copy('sys_attachment', sysAttachment.sys_id, 'kb_knowledge', target.sys_id);
}
target.update();
