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

This widget could not be displayed.

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

This widget could not be displayed.

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
Community showcase
Published Aug 22, 2018 in Marketplace Apps

How a Marketplace app tech team is achieving gender diversity

Hello! My name is Genevieve Blanch, and I'm the Marketing Manager at RefinedWiki, creators of apps to give teams the tools to customize Atlassian platforms. Currently, 44% of the tech team at Re...

513 views 3 18
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