How to dot walk approving record in approval table

[Preethi26]

Hi All,

How can we dotwalk and get the state of the change in approving field in approval table.

Kindly assists.

[Community Alums]

Hi Preethi,

You can't dot-walk to an approver because there can be many approvers on a given task. For this same reason, you can't reliably determine who the current approver is. I think the best you could do would be to query the sysapproval_approver table for any approval records that were in a 'requested' state.

var app = new GlideRecord('sysapproval_approver');
app.addQuery('sysapproval', current.sys_id);
app.addQuery('state', 'requested');
app.query();
while(app.next()){
   //Do something
}

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

[Preethi26]

Thanks for the response,

But i need to get the approval record of the change whoes state is authorize. How this can be done.

Please assits.