Attached_filed V1 (Fix Script)
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
Comments