I need to include Approval History on RITM approval notification.

Teri Bobst
Mega Guru

I have a catalog item that requires multiple levels of approvals: Manager, Director, General Manager, VP. I have the workflow for this working correctly. Now, when the approval notifications get sent out at each stage of approval, I need the approval history to show on the notification. If I can accomplish this, each management level that is required to approve will see who approved before them and when.

I have tried adding the sysapproval.approval_history to the email notification that is created from the Approval table, but it doesn't display any of the previous approvers.

Does anyone know how to add the approval history to a RITM approval notification?

Thanks,

Teri

1 ACCEPTED SOLUTION

Teri Bobst
Mega Guru

I found the answer at the thread below. I modified the code slightly to work with my instance.



Include past approvers in Approval Notification


View solution in original post

8 REPLIES 8

Teri Bobst
Mega Guru

I found the answer at the thread below. I modified the code slightly to work with my instance.



Include past approvers in Approval Notification


Teri,



Are you able to see all past approvers in your email notification? I am still having an issue outputting the data to the notification because our system is deleting the past approvers after they approve; therefore, there is no list to output. As the approval escalates through the org structure, the following comment is added to the activity log then the user is deleted from the approvals tab - "Approval history: User approval for X deleted since it no longer matches approval rule Manager Approval." Any advice you can give will be greatly appreciated!




Thanks,


Sarah


Hi Sarah, yes this is working perfectly for me. My Approvals are being generated through workflow, at the Item level and all are viewable from the Approvers tab on the related list section of the Request Item.



How are your approvals being generated and are they at the request or the item?



Thanks,


Teri


Teri,



Thanks for the quick response!



Our approvals are handled at the request level. The workflow first gets the direct manager's approval then we have two IF statements with a run script in between to check the manager's approval limit and escalate to the next if the current one does not have the proper approval limit. The script executes correctly and escalates through the chain of command but it keeps the direct manager then deletes the others as it progresses.



My thoughts were that we were missing something but I opened HI ticket and the technician said that the OOTB system does the same thing. From there I began looking at the workflow properites and business rules for approvals but have not found anything. I also thought about editing the scripts within the workflow to see if that is were the deletion was occurring; however, I do not have much scripting experience and I'm not sure where to start.



If you have successfully done this with an item, then maybe I need to explore changing the approvals to run on the item and see where that gets me.



Thanks,
Sarah