- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-04-2022 11:17 PM
Hi Everyone,
I am Developing Notification Now.
I need to get the filed value(u_platform_type) from custom table (u_platform) though the mail script.
Can you help me on mail script..
Thank you.
Solved! Go to Solution.
- Labels:
-
Incident Management

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-05-2022 01:04 AM
What table notification is on? Is there a common/primary key in your notifcation table & u_platform table?
If you you need to try something as below
(function runMailScript(current, template, email, email_action, event) {
var nameis = new GlideRecord("u_custom"); //replace table name
nameis.addQuery("xyz", current.abc); //common field name to be replaced with abc here & xyz is field that is in custom table with same value as abc in current notification table
nameis query();
if(nameis.next()) {
template.print('Platform value '+nameis.u_platform_value.getDisplayValue());
}
})(current, template, email, email_action, event);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-01-2022 12:02 AM
Hi @Siva
I see you have marked the response as helpful which is great. If you have a follow up query do post here else please mark the answer as correct and close this thread for others.
Regards,
Shloke
Regards,
Shloke