CC email address not working

[MPP22]

Hello, we have 3 below custom tables in scoped application. 1. ABC 2. DFG > This table has a reference field from table ABC 3. XYZ > This table has a reference field from table DFG Now below script built on the "XYZ" table to send an email to approvers (trying to get this data from ABC table via dot walk) in CC. But somehow could not see these approvers in CC under email logs. The below script working well in background-script and gives me approver email, name. Appreciate urgent help here to understand where could be the issue /how can we troubleshoot/fix this. var grOp = new GlideRecord('XYZ'); grOp.addQuery('sys_id', current.getUniqueValue()); grOp.query(); while (grOp.next()) { var kri = grOp.transaction; var grKri = new GlideRecord('DFG'); grKri.addQuery("sys_id", kri); grKri.query(); while (grKri.next()) { var app = grKri.ABC.approver.toString().split(","); var cnt = app.length; for (var i = 0; i < cnt; i++) { var user = new GlideRecord("sys_user"); user.addQuery("sys_id", cnt[i]); //user.addQuery("notification", 2); //email //user.addQuery("email", "!=", ""); user.query(); while (user.next()) { email.addAddress("cc", user.email, user.getDisplayValue()); } } } }

[Sai Kumar B]

@MPP22 

Try the below code with proper tabl names

var grOp = new GlideRecord('XYZ'); 
grOp.addQuery('sys_id', current.getUniqueValue()); 
grOp.query(); 
if (grOp.next()) 
{ 
var grKri = new GlideRecord('DFG'); 
grKri.addQuery("sys_id", grOp.getValue('transaction')); 
grKri.query(); 
if(grKri.next()) 
{ 
var app = grKri.ABC.approver.toString().split(","); 
}
}

var cnt = app.length; 
for (var i = 0; i < cnt; i++) 
{ 
var user = new GlideRecord("sys_user"); 
user.addQuery("sys_id", cnt[i]); 
user.query(); 
if (user.next()) 
{ 
email.addAddress("cc", user.getValue('email'), user.getValue('name')); 
} }