sysapproval reference fields for an email template

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-30-2016 08:21 AM
I'm trying to update the email approval notification template (change.itil.approve.role) to include information from an alternate change request table.
So far I have added a reference column to the sysapproval_approver table:
When I go to edit the template I can see all the fields on this alternate table:
But when I add the fields to the email template the only information that populated in the email are those on the sysapproval table and nothing from my alternate change table. Here is an example of the field name from my alternate change table:
I'm obviously missing something here or perhaps there is a better way to accomplish the same results, any help would be appreciated.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-09-2017 12:03 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-09-2017 12:10 PM
Can you go to the approval form, right click on the field u_nbschanges and click show field and post the screenshot of that.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-09-2017 12:23 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-09-2017 01:04 PM
Yes this is what I was asking. And according to this ${u_nbschanges.u_deployment_type} should work.