Attached_filed V1 (Fix Script)

PHOTO EMBED

Tue Jan 23 2024 07:49:35 GMT+0000 (Coordinated Universal Time)

Saved by @Yous

function replaceImageSysID(){

    var tableName = 'kb_knowledge';
    var recordSysId ='22788737b510b989a8690cbb35efb48e'; 
    var url = "sys_attachment.do?sys_id=";
    var attachmentArray = [];
    var regex = new RegExp('attachments/[0-9]*/');
	

    var grKK = new GlideRecord(tableName);
    if (grKK.get(recordSysId)) {
		
        var attachments = new GlideSysAttachment();
        var agr = attachments.getAttachments(tableName, recordSysId);
        var text = grKK.getValue('text');
        var rowCount = agr.getRowCount(); 
        gs.info( "Total filed attached in ALL TEXT: " + rowCount);
        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);

		}
		gs.info( "Before for: " + rowCount);
            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