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.

[oharel]

Hi Mark,

Did you try: ${sysapproval.u_nbschanges.u_deployment_type}

Other than that, instead of adding columns and fields to the approval table, did you try using an email notification script? The script will look up the relevant record and do the dot walking for you.

harel

[drjohnchun]

Can you try

${sysapproval.u_nbschanges.u_deployment_type}

Hope this helps.

Please feel free to connect, follow, mark helpful / answer, like, endorse.

John Chun, PhD PMP

Winner of November 2016 Members' Choice Award

[Abhinay Erra]

Here he added a new field to the sysapproval_approver table. So it shoule be ${u_nbschanges.u_deployment_type}

[drjohnchun]

got it.