Attached_filed V2 (Fix Script)

PHOTO EMBED

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();
content_copyCOPY