Get value of another table in Notification
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2023 08:25 AM
Hi , i created a Notification in sys_approver table. In section What it will contain, i want to show or to get value of field of another table? i try to do this:
${{table_name.field_name}}
is this the correct way?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2023 04:22 PM
Hi @mauro23 note that notification works at a record level of the record that triggered the notification. so what you are trying to do won't work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2023 04:26 PM
Hi @mauro23 note that notification works at level of record that triggered the notification; so your approach won't work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2023 10:45 PM
Hey,
In ServiceNow, to reference a field from another table in a notification, you can use the standard dot-walking syntax. However, the correct syntax does not include double curly braces (${{ ... }}). Instead, you can use a single set of curly braces with the dot-walking syntax like this:
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2023 11:36 PM
Hi @mauro23 ,
If you have reference field in sys_approver table for target field then you can use
${user.phone} //user table phone number field.
If you dont have refrence then you have to create mail script glide that target table and print in email script and use in notification like ${mail_script:yourmailscriptname}
Please mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand
