Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,473
Community Members
 
Community Events
176
Community Groups

Searching by approvers field in JIRA

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.

4 answers

2 votes
Tansu Akdeniz Community Leader Jul 08, 2019

Hi @tokuda ,

Please check this one:

  • Approvals = approver("TANSU")

It finds requests that require or required approval by Tansu.

Functions:

image.png

 

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

Hope it helps.

Tansu

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`.

Like Samuel P likes this

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 Community Leader Feb 04, 2021

Hi,

You can simply use 

  • Approvers = currentUser()

OR

  • Approvers = userA

What do you want to search specifically?

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.

Like # people like this

This was Great and helped me - thanks a lot

1 vote

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.

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.

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.

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.

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)

Suggest an answer

Log in or Sign up to answer