Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Find all issues which were approved by the user

I have an automation for cascade approval system where multiple approvers approve. The issue is not seen non before nor after the approval to the approver. How do I find the issues for particular approver to bring ability of listing the issues where the current user was approver and approved it?

There is also an automation to comment the issue on approval with text saying Approved by {{issue.assignee.displayname}} maybe this helps to find all such issues?

2 answers

1 accepted

0 votes
Answer accepted
John Funk Community Leader May 26, 2021

Hi Javanshir - you should be able to run a query like:

project = JIRA and "Approvers[User Picker (multiple users)]" = currentUser()

where JIRA is the project you want to see. 

Hi John,

Nope, this didn't work. In the fields I see the following fields:

Approver

Approver 1

Approver 2

Approver 3

Approver 4

Approvers

I've changed the JQL to the following:

project = "Project name" AND "Approver[User Picker (single user)]" = currentUser() AND "Approver 1[User Picker (single user)]" = currentUser() AND "Approver 2[User Picker (single user)]" = currentUser() AND "Approver 3[User Picker (single user)]" = currentUser() AND "Approver 4[User Picker (single user)]" = currentUser()AND "Approvers[User Picker (multiple users)]" = currentUser()

This brings no matching results for the employee that is approving constantly.

John Funk Community Leader May 27, 2021

What do the values look like for a single row (issue) where the current user has approved it. One that you KNOW for sure that he/she approved it. 

This is requested for a cascade approval tickets system, where a custom field is used and then a variable comes into an action. Maybe this sheds more light?

John Funk Community Leader May 31, 2021

I am afraid that doesn't help any. Can you answer my last question? If there has been an issue that is approved, what do the values look like in the fields for that issue for the Approver field(s)?

If the Approver, Approver 1, Approver 2, etc. field/s is containing an employee the automation rules apply when the approvers move the issue to appropriate statuses.

There is no special value for an approved issue only automated comment by employee name to the comments section as mentioned in the initial post.

John Funk Community Leader Jun 03, 2021

project = "Project name" AND "Approver[User Picker (single user)]" = currentUser() AND "Approver 1[User Picker (single user)]" = currentUser() AND "Approver 2[User Picker (single user)]" = currentUser() AND "Approver 3[User Picker (single user)]" = currentUser() AND "Approver 4[User Picker (single user)]" = currentUser()AND "Approvers[User Picker (multiple users)]" = currentUser()

Change the ANDs between approvers to OR - like this:

project = "Project name" AND ("Approver[User Picker (single user)]" = currentUser() OR "Approver 1[User Picker (single user)]" = currentUser() OR "Approver 2[User Picker (single user)]" = currentUser() OR "Approver 3[User Picker (single user)]" = currentUser() OR "Approver 4[User Picker (single user)]" = currentUser() OR "Approvers[User Picker (multiple users)]" = currentUser())

Like Javanshir Mustafayev likes this

Great, that's what I thought should be done to make this work. Thanks for helping out!

Like John Funk likes this

Hi @Javanshir Mustafayev 

Is this a Jira Service Management (JSM) project?  If so, you may be able to use:

project = myProject and approvals = myApproval()

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-myApprovalmyApproval--

Best regards,

Bill

Hello Bill, no it's not a JSM project, anyway thanks for your input.

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira

Admins, notify your Jira instance of system-wide changes with the new admin announcement banner

Hi All! We’re excited to share the launch of an announcement banner that lets Jira site administrators communicate directly to their users across Jira Cloud instance.   📢 Get y...

251 views 12 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you