Can I create a queue to show who has not approved a change

We have multiple people who have to approve a change so i want to create a queue or a filter which shows me who hasn't approved it.  I know i can see which changes are pending approval but i want the persons name who hasn't approved it.  If you cant do it through the GUI can you tell me what table in the database would show this.  I can see the Change Approvers field in CustomFields table and I can see who is meant to approve the change in CustomFieldValue but not whether they have approved it or not.  Please can you help.

1 answer

1 vote
Jack Brickey Community Champion Nov 17, 2016


i have just recently set up a project that requires approvals (two levels) and haven't had much experience with this. However, Approvals = pending() does seem to provide the approvers that are outstanding. You need to display the Approvers field/column. I did note however, in my case anyway, the filter results includes those issues that were declined or resolved which i find odd. So I simply modified the JQL to Approvals = pending() and status not in (declined, resolved).

Hope this helps.

Jack Brickey Community Champion Nov 17, 2016 i know why the declined/resolved show as pending approval. it is simply because no approver was added when ticket created and the agent simply worked around the approval via a third-transition. So i think the first JQL should work. Keep me posted on your experience.

Thanks for your suggestion Jack.  i too have created a queue with Approvals = pending() and included the Approvers field which shows me all the people who need to approve but ideally I'd also like to see a list of the approvers who haven't approved it.  The reason being we can easily see who is left to approve it and chase them up rather than having to look in to each change itself.

Jack Brickey Community Champion Nov 17, 2016

Got it. I haven't found a means of doing that and in fact my current use case/implementation doesn't require it as it is more of a 1:1 approval. I created two approval statuses. The step is to get approval from 'manager' and if approved it automatically transitions to 'cfo' for approval. I looked further into this to see if there was an existing support request but did not find one. It seems like a useful suggestion for sure so you may wish to open a ticket w/ Atlassian.

Thanks Jack - I appreciate your help!

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,323 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot