How do I build a report to see all upcoming Task Approvals based on role ID?

[AndrewGr1]

For my Proofreading team, I would like to have a report to see all upcoming task approvals based on a role ID to see what work may be coming through. I tried messing with EXISTS statements from previous forum posts to see if I could manipulate any, but I didn't have any luck. The approvalStep name usually contains "Proofer" as well, but I couldn't figure out a way to filter by that either. I appreciate any suggestions on how to approach this. I don't want to only see current/active approvals either; I want to see all projects with task approvals that could come through. 

Thanks for any support!

[Sven-iX · Accepted solution]

Hi @AndrewGr1 

a task has a collection "approvalStatuses" you can use.

Try an EXISTS filter like this and replace "###" with the roleID you need. 

EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=ARVSTS
EXISTS:a:stepApprover:roleID=################
EXISTS:a:taskID=FIELD:ID