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?

Regards,

Stefan

2 answers

The following query should meet your requirements.

 

SELECT AO_D195E9_APPROVAL_HISTORY.EXECUTOR  /*what person gave approval 
FROM AO_D195E9_APPROVAL_HISTORY
inner join jiraissue on AO_D195E9_APPROVAL_HISTORY.ISSUE_ID= jiraissue.ID
inner join issuestatus on issuestatus.id= jiraissue.issuestatus  
WHERE issuestatus.pname= 'Closed'           /* ...to 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,

Antonella

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?

Regards,

Stefan

I confirm, It is not available as a JQL.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published Thursday in Marketplace Apps

Calling all developers––You're invited to Atlas Camp 2018

 Atlas Camp   is our developer event which will take place in Barcelona, Spain  from the 6th -7th of   September . This is a great opportunity to meet other developers and get n...

128 views 0 5
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