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

[Mike Allen]

You can use the sys_updated_on field to get date/time this record was updated.   That should work.

[Armin Heinlein1]

Mike,

Thank you for getting back to me. The sys_updated_on field doesn't work for me since it shows the last date the record was updated and not really the true date/time when the approval was given.

What I don't get is, where is the activity shown on the screen copy coming from. If I can get that I am happy.

Armin

[Mike Allen]

You can look in the sys_history_line table to see when it was changed from Requested to Approved.   But, that table is large, so be careful querying it.

[arnabbose]

These Columns on the Approvals table should give you all the Info you need...