sysapproval reference fields for an email template

kistler1
Giga Contributor

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:

find_real_file.png

find_real_file.png

When I go to edit the template I can see all the fields on this alternate table:

find_real_file.png

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:

find_real_file.png

I'm obviously missing something here or perhaps there is a better way to accomplish the same results, any help would be appreciated.

13 REPLIES 13

kistler1
Giga Contributor

I tried both methods and neither seem to be working and yes the field is populated


find_real_file.png


Can you go to the approval form, right click on the field u_nbschanges and click show field and post the screenshot of that.


kistler1
Giga Contributor

I'm not sure if this is what you are asking for?


find_real_file.png


Abhinay Erra
Giga Sage

Yes this is what I was asking. And according to this ${u_nbschanges.u_deployment_type}   should work.