You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
In JIRA Service Desk, how can one query for Service Request tickets without approvers?
status = "Waiting for approval" AND resolution = Unresolved and Approvals = ???
In Jira, the "Approvals" section is always based off of a user picker custom field. This might be the field "Approvers" it might not be. You can figure out what the field is like this:
1) Navigate to the project you want to query for issues from
2) Look at the workflow that requires approvals and click on the status that requires an approval
3) Identify the custom field being used.
In my case, this field is the approvers.
If I want to search for tickets like you are requesting, I would need to query for tickets where "Approvers is EMPTY".
If you cannot search for "IS EMPTY" and you get an error such as the following:
Field 'approvers' is not searchable, it is only sortable.
Go into your custom fields, locate the field you configured for your approval (in my case "Approvers") and click "Edit". Change the search template to "User Picker & Group searcher". Then kick off a reindex and search away!
Hope this helps!
Yep! It would show you all tickets that have an approver but haven't been approved.
If you found this answer useful, please accept it so others know as well.