Searching by approvers field in JIRA

[tokuda]

I use JIRA cloud. And my team uses "approvers" field to request for reviewing casually. But I seem that we can not search by "approvers" field by using JQL. Please teach me how to search by "approvers" field on JIRA.

[Zack Zhang]

Go to your Issue settings > FIELD > Custom Fields.

Choose Approvers > Edit Details, Change "Search Template" from None to "User Picker & Group Searcher"

Then you can search approvers in JQL.

[Jawann Swislow]

This is the answer. Should be at the top. Thank you.

[Tansu Akdeniz]

Hi @tokuda ,

Please check this one:

• Approvals = approver("TANSU")

It finds requests that require or required approval by Tansu.

Functions:

Detailed info: https://confluence.atlassian.com/jiracorecloud/advanced-searching-fields-reference-765593716.html#Advancedsearching-fieldsreference-ApprovalsApprovals

Hope it helps.

Tansu

[tokuda]

Thanks for your comments.

But my team doesn't use `Jira Service Desk`, so I can't use the function `Approvals`.

I want to filter by `approvers` without `Jira Service Desk`.

[Muaz Othman]

Hi @Tansu Akdeniz 

As @tokuda mentioned, this field is only available in "Jira Service Management" per the documentation you linked to.

Any suggestions on how to get a similar functionality in Jira Cloud?

[Tansu Akdeniz]

Hi,

You can simply use 

• Approvers = currentUser()

OR

• Approvers = userA

What do you want to search specifically?

[Muaz Othman]

Tried this simple query:

project = "LG" AND Approvers = currentUser() ORDER BY created DESC

and got this error:

Field 'Approvers' is not searchable, it is only sortable.

[Jyoti Verma]

This was Great and helped me - thanks a lot

[Jeret Shuck]

I'm also looking for something similar. Effectively, I need something that is 

"Approvers is empty"

As others have posted, it seems like there is no way to use a JQL function on the "approvers" field on the Jira cloud currently.

[Jawann Swislow]

Answer here from @Zack Zhang: https://community.atlassian.com/t5/Jira-questions/Searching-by-approvers-field-in-JIRA/qaq-p/1125516#M558442

[Jason Sweet]

Hello and sorry to hijack this question but I have the same problem.  I'm trying to filter on a specific name in the Approvers field, across multiple projects, some of which are service desk and some are classic business.  

I have tried:

status = "Awaiting Approval" AND Approvals = approver("rmitchell") ORDER BY created DESC

and get No Issues found.

Any advice here?  Thank you very much in advance.

[Vanessa McGonigle]

If the approvers field contains more than one user that jql will not identify the issue as relevant to the jql. I'm not sure what the right query is though.

[Corey Needham]

You can use the OR function to separate queries to both fields to return all of the results.

status = "Awaiting Approval" AND Approver = 5d7bd791458a170db4b0a687 OR status = "Awaiting Approval" AND Approvals = approver("Jason Sweet")

Where 5d7bd791458a170db4b0a687 is Jason Sweet's ID , it will return both Software and Servicedesk issues that Jason sweet has been or is an approver on that is currently "Awaiting Approval"

(TIP: if you type out the "Approver =  " part of the query you can search users by name and it will input the ID)