Re: update ritm sysid in the target record field i...

ShaziyaS1041050 · ‎11-11-2025

var match = email.subject.match(/(MSN\d{7})/);

var subj = email.subject.toLowerCase();

if ((subj.startsWith("re:") || subj.startsWith("fw:") || subj.startsWith("fwd:")) && match) {

gs.info("record found: " + match);

var recId = match[0];

var gre = new GlideRecord('x_att2_fir_net_mob_msnow_email_request');

gre.addQuery('number', recId);

gre.query();

if (gre.next()) {

gs.info("gre.parent: " + gre.parent.number);

if (gre.parent) {

gs.info("parent not empty");

gre.work_notes = email.subject; //TO SET WORKNOTES OF MSN

gre.update();

var old_current = current.sys_id;

gs.info(" curret.sys_id: " + current.sys_id);

//current.target_table=sc_req_item;

current.sys_id = gre.parent; //TO SET CURRENT AS RITM

gs.info("gre.parent.: " + gre.parent);

//current.needs_attention = true;

current.update();

gs.info("after updt curret.sys_id: " + current.sys_id);

var rel_ritm = new GlideRecord('sc_req_item');

rel_ritm.addQuery('number', gre.parent.number);

rel_ritm.query();

if (rel_ritm.next()) {

rel_ritm.needs_attention = true; // to set need attention in RITM

rel_ritm.update();

}

var sysEmailGR = new GlideRecord('sys_email');

sysEmailGR.addQuery('instance', old_current);

sysEmailGR.query();

if (sysEmailGR.next()) {

gs.info("email found");

sysEmailGR.target_table = 'sc_req_item';

sysEmailGR.instance = gre.parent.sys_id;

sysEmailGR.update();

gs.info("email updated");

}