Attached_filed V2 (Fix Script)
Tue Jan 23 2024 13:07:56 GMT+0000 (Coordinated Universal Time)
Saved by @Yous
function replaceImageSysID(){ var tableName = 'kb_knowledge'; var url = "sys_attachment.do?sys_id="; var attachmentArray = []; var regex = new RegExp('attachments/[0-9]*/'); var grKK = new GlideRecord('kb_knowledge'); grKK.addEncodedQuery("kb_knowledge_base=7b45de6187b3c5541cec670a0cbb35db"); grKK.orderBy('number'); grKK.setLimit(15); grKK.query(); while (grKK.next()) { var sysID = grKK.getValue('sys_id') var grKK2 = new GlideRecord(tableName); if (sysID) { gs.info('sysID ' + sysID); var attachments = new GlideSysAttachment(); var agr = attachments.getAttachments(tableName, sysID); var text = grKK.getValue('text'); while(agr.next()){ var src_img = text.match(regex); //var src_img = "attachments/"+ grKK.meta + "/"; var attachment = {}; attachment.sys_id = agr.getValue('sys_id'); attachment.file_name = agr.getValue('file_name'); attachmentArray.push(attachment); } for (var i=0; i< attachmentArray.length; i++){ var elem_sysId = attachmentArray[i].sys_id; var newelem_sysid = url + elem_sysId; var elem_file_name = src_img + attachmentArray[i].file_name; // var elem_file_name = src_img ; var changed_url = elem_file_name.replace(elem_file_name,newelem_sysid); var check = grKK.text.includes(elem_file_name) ; gs.info( "INSIDE for: " + elem_file_name); //if(check != true){ gs.info(" SYSID: \n" + elem_sysId + "\n Filename: " + elem_file_name ); gs.info("\n Changed url : \n" + changed_url); //grKK.text = grKK.text.replaceAll(elem_file_name,changed_url); // } } //grKK.update(); } } } replaceImageSysID();
Comments