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

[Murthy Ch]

Hi @MPP22 

If those logs are not coming then there is an issue in above lines.

What is this ABC here?

 var app = grKri.ABC.approver.toString().split(","); 

I think that is causing the issue.

Is that a proper field name?

[MPP22]

yes it is as its working in the background script. Surprisingly not one simple info statement (before and after loops) can see in system logs. This script gets called in Notification. 

[Murthy Ch]

Hi @MPP22 

So have you called the email script correctly in notification?

${mail_script: mailscriptname}

Can you share the screenshots if possible?

Can we have a quick Gmeet: manichintalapudi9@gmail.com?

[MPP22]

@Murthy Ch - Came to the conclusion after some changes. The script after the while loop (while (user.next()) {) is not working and not getting this info in logs. Any heads up why sysid is not getting matched with approver sysid as its exist in user table.

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", "=", app[i]);
gs.info("in submit script 4 "+app[i]);
user.query();

while (user.next()) {
var email = user.email.toString();
var name = user.name.toString();
gs.info("user email: "+email);
gs.info("user name: "+name);
email.addAddress("cc", email, name);
//email.addAddress("cc", user.email, user.getDisplayValue());
}

[Murthy Ch]

Hi @MPP22 

Not really sure.

Have you checked what is coming in this info?

Is it giving active user sys_id?

gs.info("in submit script 4 "+app[i]);