Can you dot walk from sysapproval to change

[pat6907]

Hello all,

Is it possible to dot walk from sysapproval to change?

I want to create a notification that is based off of the sysapproval table but links back to the change table to grab a few fields that are not available in the sysapprover table.

if it sis not possible from a notification, would it be possible to create a mail script to grab the change field values needed by keying off of the (request) number field in the sysapprover table?

Many thanks

Pat

[Jaspal Singh]

Hi,

You have sysapproval field which is a reference field that has record for which approval is to be done on the sysapproval_approver table.

You can use sysapproval.change_table_field

Thanks,

Jaspal Singh

Hit Helpful or Correct on the impact of response.

[pat6907]

Hi Jaspal,

I tried that approach using the following as you suggested.

${sysapproval.u_usedby_group}

When I clicked the 'Preview Notification' button to test it, the pop up did not launch the window.

When i removed that line from the Message HTML field, the pop up launched as expected.

The u_usedby_group field is found on the change-request table but not on the sysapproval table.

Might you have any other suggestions?

Much appreciated

Pat

[Jaspal Singh · Accepted solution]

Hi,

It should work. Also, even if the field is not found the pop-up will still appear. Can you check the field name once & also look for the record that has u_usedby_group field value populated correctly. I guess when you do a preview notification system would be picking the record that has u_usedby_group field as empty.

Thanks,

Jaspal Singh

Hit Helpful or Correct on the impact of response.

[SatheeshKumar]

you can use sysapproval field to get  all the values of chnage record for which th approval is triggered

sysapproval.number --> chnage request number

sysapproval.short_description --> short description of change.

sysapproval.sys_class_name  --> table for which the approval is triggered

if you are using emil script then you need to use :

current.sysapproval.number --> chnage request number

current.sysapproval.short_description --> short description of change.

current.sysapproval.sys_class_name  --> table for which the approval is triggered