Jira Issue Filter for pending approvers

[Ron Campbell]

I have a filter I am trying to build for a user and I cannot get it to work the way it should. We have a field called signoff approvers that multiple users must signoff on before it can be closed. She has approved the issue but others have not and it still shows up on her filter for to-do work so she has a hard time finding ones she has not completed without opening every issue. I have tried many different ideas so far. Below is an example of my last one. 

project = "myservicedesk" AND "Signoff Approvers" = "john.smith@business.net" AND "Signoff Approvers" != pendingBy("john.smith@business.net") and status not in (Done, Rejected, Canceled, "On Hold")

[Ron Campbell]

Sorry wrong spot to reply

[Harrison Ponce]

Hi @Ron Campbell! You should be able to accomplish this with the following piece of JQL (like this or using your approval field):

"Approvals[Approvals]" = myPendingApproval()

That will only return issues where the current user has a pending approver. So if they approve, the issue will drop off their JQL.

Hope that helps! 

[Ron Campbell]

When I tried that before it gives me the following error. 

Field 'Approvals[Approvals]' does not exist or you do not have permission to view it.

I am a Jira Admin and I am not sure what permission I would not have already setup that would allow this. 

[Harrison Ponce]

That's probably because it's not the exact name of the field it's referencing. If you are interested, I would be happy to connect with you on a video call to look at it (connect with me here)! We use it quite successfully but definitely have to swap out the field name depending on the project.

[Ron Campbell]

"Signoff Approvers[Approvals]" = myPendingApproval() is that not the correct way to setup the JQL?