Pulling the fields through from another table into a Notification email body

sureshpcse — Thu, 25 Jul 2024 02:41:24 GMT

How would I pull a field through from one table into a notification template or email based on another table?

I'm trying to pull through the details of a Affected Ci (task_ci table) fields as technology manager ; name and put them in an notification email template (change_request table).

and I'm not sure what the syntax would be to do this, I've tried various variations on ${table name.field name} but nothing seems to be working.

Any ideas?

Re: Pulling the fields through from another table into a Notification email body

Bhavya11 — Fri, 26 Jul 2024 10:00:30 GMT

hi @sureshpcse ,

you can refer below email script but need to modify the field according to the technology manager. believing that you have created the notification on the change table so

(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template, /* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action, /* Optional GlideRecord */ event) { var taskci = new GlideRecord("task_ci"); taskci.addQuery("task", current.sys_id); taskci.query(); while (taskci.next()) { var gr1 = new GlideRecord("cmdb_ci") gr1.addQuery("sys_id", taskci.ci_item); gr1.query(); if (gr1.next()) { template.print("OWNED BY IS : " + gr1.getDisplayValue('owned_by')); // add your field name here } } })(current, template, email, email_action, event);

If my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful."

Thanks,

question Pulling the fields through from another table into a Notification email body in Virtual Agent forum

Pulling the fields through from another table into a Notification email body

Re: Pulling the fields through from another table into a Notification email body