Who approved my request?

Paul Brown_4syppx

I'm trying to create a JQL query to list all request approved by a specific agent, i've tried the following:-

"Approvals[Approvals]" = approved() and "Approvals[Approvals]" = approver("paul brown")

(The Approvals field contains a list of several approvers, and the workflow configured so that only one is required)

The JQL returns all issues that have been approved and that "paul brown" is listed as one of the approvers in the approvals, but not just the request approved by him.

Am I missing something?

Dirk Ronsmans

Hi @Paul Brown ,

Your query seems to be the way to go although depending on the setup if could be a little shorter ofcourse.

 

"Approvals[Approvals]" = approved() and "Approvals[Approvals]" = approver("paul brown") and status changed FROM 'Waiting for approval' to 'in progress' BY 5a329438b2e85440fa726df0

could just be

"Approvals[Approvals]" = approved() and status changed status changed FROM 'Waiting for approval' to 'in progress' BY 5a329438b2e85440fa726df0

 

Would not make sense that someone that is not in the approvers list to approve it and it would catch it if he somehow was able to do it anyway.

Other than that It looks like you found your own solution! Afaik there is no "approvedBy" property (yet) so the status changed by looks to be a good work arround.