question Reporting on approvals in Developer forum

Reporting on approvals

sguthrie — Wed, 06 Jan 2016 21:23:54 GMT

I have a Request item with approvers in the Workflow. I want to report on who approved/rejected each step. I tried from the Approval (sysapproval_approver table) but can't find how to dot walk to the item. Is this possible? ~Thanks.

Re: Reporting on approvals

Raju Koyagura — Thu, 07 Jan 2016 05:10:24 GMT

Create report like below, I am not sure is the same thing you are looking for....

Re: Reporting on approvals

Ajai S Nair — Thu, 07 Jan 2016 06:58:01 GMT

Hi Sherri,

You can try with the report Raju mentioned above. If you want to get the complete details of approvals for a single request item then give the filter as Approval for is <RITM number>.

Re: Reporting on approvals

sguthrie — Thu, 07 Jan 2016 16:12:30 GMT

Perfect! Thanks. Each approval has a group assigned to it. The last field I need is this group. Is this possible? Also, is there a way to see table relationships to help me with the dot walking? Thanks for your help.

Re: Reporting on approvals

Raju Koyagura — Thu, 07 Jan 2016 16:52:46 GMT

Yes, you can add assignment group as well. Dot walk can be done for a reference field, if you select refernce field like "Approval for" in the available section you will find "+" symbol beside to the available section. Just click on that '+' symbol to get that specific table fields.

Please mark it correct answer, if this answer your question.

Re: Reporting on approvals

sguthrie — Thu, 07 Jan 2016 17:00:06 GMT

Approval for.Assignment group is blank for me. The group is assigned in the Workflow-Activity Properties: Approval-User. This group is assigned to receive the approval emails.

Re: Reporting on approvals

Raju Koyagura — Thu, 07 Jan 2016 17:44:50 GMT

In workflow activity even though you used approval group, it won't create a single approval record for that group. Instead it creates n number of records based on the group members and each member can get one approval record.

Sent from my iPhone