sysapproval reference fields for an email template

[kistler1]

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.

[Abhinay Erra]

What you have is correct here. Can you make sure if u_nbschanges field was populated ?

[oharel]

And to add to abhinay   - make sure that u_deployment_type is populated...

harel

[drjohnchun]

Can you post the screenshot of the top portion of the email template showing the Table field?

[drjohnchun]

I just want to make sure we're all working off the same table in your email template as I'm not sure why there are all these "sysapproval" prefix in your field names.

[drjohnchun]

On another look, it looks like you're dot-walking using the sysapproval reference field into the task table (base of change_request) from the sysapproval_approver table.