fields not pulling in data in notification emails

[scottjus82]

Hi,

I am ammending our approval request notification email to include start and end dates of the change as well as the business service. the first three are puling in the data in the fields but the rest do not, they just display the field name but no data. I have tried referencing these fields from different tables but always the same results.

Approval for: ${sysapproval}Short Description: ${sysapproval.short_description}

Priority: ${sysapproval.priority}

Category: ${sysapproval.category}

Business Service: ${u_category_level_1}

Planned end date: ${end_date}

Planned start date: ${start_date}

Any thoughts?

[pavan_poul]

Hi Steve,

I think you missed to insert the table name for last 3 fields

Business Service: ${tablename.u_category_level_1}

Planned end date: ${tablename.end_date}

Planned start date: ${tablename.start_date}

Thanks,

Pavan Poul

[scottjus82]

Hi,

Thanks for the quick response. I have added change_request to each field

however I still get the same response. my notification now looks like the

below. I have included what the email shows as well

Approval for: $Short Description:

${sysapproval.short_description}

Priority: ${sysapproval.priority}

Category: ${sysapproval.category}

Business Service: ${change_request.u_category_level_1}

Planned end date: ${change_request.end_date}

Planned start date: ${change_request.start_date}

Email received.

Approval for: CHG0031793Short Description: Whitelisting Plan / AMEND

EXISTING DATAGROUP (F5)

Priority: 4 - Low

Category: Other

Business Service:

Planned end date:

Planned start date:

[RKumar3]

Reason for this issue is that "Approval For" field refers to "Task" table and task table does not have fields like end_date, start_date(They are on extended table from TASK i.e. change table in your case) etc. You need to to fetch the actual change record in the notification and set the values of start and end date afterwards.

[scottjus82]

Hi,

thanks for the response. Can you advise how I woud do that? as in fetch the actal change record and then set the values?

Thanks