Hi folks,
Shout out to @skyehansen...
I had made note of your Approval Status Collection filtering technique when you first raised it, and returned to it today to DRASTICALLY simplify some project report approval filtering for one of my other SysAdmin colleagues. Instead of checking for certain Approval Step names and/or certain Approvers (which are continually evolving, and therefor required continual maintenance on multiple report filters), we adapted your approach to this pattern:
AND:1:EXISTS:a:$$OBJCODE=ARVSTS
AND:1:EXISTS:a:projectID=FIELD:ID
AND:1:EXISTS:a:status=AA
AND:1:EXISTS:a:stepApprover:userID=$$USER.managerID
EXISTS:a:$$OBJCODE=ARVSTS
EXISTS:a:projectID=FIELD:ID
EXISTS:a:stepApprover:userID=$$USER.ID
Using the above in a filter on a Project report:
- the logged in user ($$USER.ID) can now easily see
- any Project where they were among those people approving the project (stepApprover) that is
- Awaiting Approval (AA) by their manager ($$User.managerID)
- from their manager's perspective -- as if they could "Log In As" their manager
- prepare for questions accordingly
This approach ensures the accuracy, transparency, and real-timeliness of the information, AND (bonus marks) by focusing on the USER.ID and USER.managerID, spares the SysAdmin the effort and frustration of trying to keep up with evolving Approval Path logic.
Thank you again: this was huge win.
Regards,
Doug