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?
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
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG