Who approved my request?

[Paul Brown]

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 · Accepted solution]

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.

[Paul Brown]

Thanks Dirk!

[Paul Brown]

Just tried this and it seems to have worked, but was hoping for a more JQL friendly solution? 

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

 Paul.