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 Sign up to answer
Community showcase
Published Thursday in Jira

Updates to give you visibility into what's coming in Jira Server and Data Center

Hello, Community! My name is Gosia and I'm a Product Manager on Jira Server and Data Center here at Atlassian. Since 2002 when we launched our public issue tracker, jira.atlass...

318 views 1 12
Read article

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