Need to create report showing approver and when the approval was given

[Armin Heinlein1]

I need to create a PDF document showing the approver and when the approval was given.

No problem with getting the approver (sysapproval_approver) and the comments but from where do I get the actual date and time of the approval from? I can see it under activities but I not getting that info with the getJournalEntry(-1) method.

This is what I get if there is a comment. No state changes

[Armin Heinlein1]

Arnab,

The workflow activity can't be selected in my instance. I don't know why. The record that I am approving resides in a scoped application   and is a Base Class table.

[Margie2]

I am creating a report from the sc_task table and was able to drill into the Requested item table to get several fields I needed for the report.  I cannot, however, figure out how to add the approver to my report.  It seems like it should be here since all our items need approval before the first task is generated.  But I don't see it.  Can anyone help?  If I go to the [sysapproval_approver] report, I can't get the other fields I need.

[abhishekdash]

Hello Armin:

Here is how you could do it:

1) Navigate to reports

2) Create a report on Approval [sysapproval_approver]

3) Add the fields Approver, Approval for, Approval for.Approval Set

4) Below is a screenshot for the same:

Please note that it will work for only tables which are inherited from task, as 'Approval set' is from task table.

I hope this helps.

If this reply assisted you, please consider marking it Correct, Helpful, or Like it.

This helps other customers to learn from your thread.

Thanks,

Abhishek

[Armin Heinlein1]

Abhishek,

The record that I am approving resides in a scoped application and is a Base Class table.

[abhishekdash]

Okay. The easier solution would be to create a field and have a business rule to update that field with the time stamp when state moves to approved.

Thanks,

Abhishek