Show All Issues Ever Assigned to a User?

Craig McManus
Contributor
April 11, 2019

I know this may be a long shot, but the community hasn't let me down yet!

 

Within my organisation, users will pick up a ticket, assign it to themselves, work on it, resolve the issue and then un-assign the issue from themselves (I know, I'm trying to get them to stop doing this, but that's another battle).

 

Is there any way that I can produce a report (even if it's a JQL query into a CSV file) that will show me every issue a user has ever had assigned to them EVEN IF they are not the current assignee?

 

Essentially, I'm trying to find out how many issues each user has worked on without having to go into each issue.

 

Hope you can help!

4 answers

1 accepted

15 votes
Answer accepted
Craig McManus
Contributor
April 11, 2019

I may have answered my own question here a JQL query with the following:

 

assignee was <username>

 

This will show all issues that have ever been assigned to the user, regardless of the current status of the issue.

 

I'll leave this open for a few days on the off-chance anyone has some super-duper fancy way of doing it

caglad
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 29, 2020

When you go to settings - can you see "User Management" - if not, you are not a site Admin.

6 votes
Harpreet Sidhu
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 11, 2021

If that doesnt work, try 

was in <username>

Andy Leisen
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 16, 2021

Thank you!

1 vote
Yury Semakov
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 21, 2022

assignee was currentUser()

that works for me

Kevin Suter
Contributor
April 12, 2022

Does not work for me (Jira cloud)

screenshot_5579.png

kyle.beloin
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 2, 2022

This worked for me:

CleanShot 2022-08-02 at 15.21.26@2x.png

Like # people like this
eliran biton
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 6, 2022

works like magic

0 votes
Haresh Joshi
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 14, 2024

Hi, it worked for me also. However, I want to update that the organization may have an alias name (employee id) mapped to the username. It has to be included in double quotes even though employee id is all numbers.

Suggest an answer

Log in or Sign up to answer