Who actually approved a request?

[Glen3]

Users that approve requests can have delegates approve requests for them. As far as I know, when a delegate approves the request, the approval record shows the approver user's name, not the delegated user's name whom actually approved it.
I need to create a report that shows the user that actually approved the request. Is there a table or something that shows who actually approved requests?

[Allen Andreas]

Hi,

Outside of creating a metric to specifically capture this, the only "easy" way would be to report on the sysapproval_approver table and look at state is approved and then view the updated by (this would only work if the last update to that record was in fact by the person who approved it).

Otherwise, you'd have to report on the audit of the record/sys_history_line table to for approval records where the new value = approved and then you can get the literal user who did that from the User field.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Glen3]

Ok, thanks Allen!

[Melissa Berry · Accepted solution]

I was able to accomplish this by adding a new field on the approval table 'Approved by' and creating a after update business rule to update that field.

[Glen3]

Thanks Melissa, this is great!