Search for Approvers later

Dear Sir/Madam,

Is it possible to search when a ticket is closed on the persons that approved on behalf of a group?

For example we have an approval called "Implementer Approver". Persons that can approve this approval are in group "RFC-IR-Approver". 

The group contains 5 people, and everybody is giving approvals on behalf of that group.

Now I want to know what person of the group "RFC-IR-Approver" gave approval for all tickets in the last month for the approval " Implementer Approver".

Is there a query and how can I find this?



2 answers

The following query should meet your requirements.


SELECT AO_D195E9_APPROVAL_HISTORY.EXECUTOR  /*what person gave approval 
inner join jiraissue on AO_D195E9_APPROVAL_HISTORY.ISSUE_ID= jiraissue.ID
inner join issuestatus on jiraissue.issuestatus  
WHERE issuestatus.pname= 'Closed'           /* search *when a ticket is closed* 
and date >=  '01/03/2016' and date <='31/03/2016'/* gave approval in the last month
and approval_detail = 'RFC-IR-Approver'     /* person of the group "RFC-IR-Approver" 
and approval_name= 'Implementer Approver'   /* for the approval " Implementer Approver"
and action= 'Approved';                     /* gave approval


Best Regards,


Dear Antonella,

Thank you very much for this! I can work something out myself now.

Just to confirm, this is not available as a JQL right in JIRA itself, and can only be done by SQL the database?



I confirm, It is not available as a JQL.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 13, 2019 in Marketplace Apps

Marketplace Spotlight: Marketing apps for Confluence to keep your teams working on the same page


223 views 0 6
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