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?

[DrewW]

All you need to do is this

Planned Start: ${sysapproval.start_date}

Planned End: ${sysapproval.end_date}

Downtime/Outage: ${sysapproval.u_downtime_outage_}

This is what I do in all of our approval notifications for change requests and it works fine.

[scottjus82]

Hi Drew,

I am certain I tried exactly that however I must have had a typo somewhere as a copy and paste of yours worked. I have added business Service using your method and that worked as well.

How does this working as these fields do not appear in my approval table.

Thanks again.

[DrewW]

Its simply a dot walk.   The field picker that is on the right only shows fields from the table directly referenced.   But the sysapproval field is a reference field (to the task table) so it points at a record and all of the fields for that record even if those fields are in a child table of the table referenced by the field.

You can do things like

${sysapproval.assignment_group.manager.email}

and get the assignment groups managers email address.   If that actually made sense.

Dot walking is your friend but you can only really rely on it on the server side.   Client side glide records are not as robust.

[Andre Moreira]

Hi All,

For additional information about Approval Notification, I usually check it out the link below:

Notification Examples - ServiceNow Wiki

[]'s

Andre Moreira

[pavan_poul]

Hi Steve,

In this case I think you have to use script with tag <mail_script> in message.

var ia = new GlideRecord('table name');

ia.query();//query

if ( ia.next() )

{}

If you got your answer then plz mark as answered.

Thanks,

Pavan