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

How do I search for issues Resolved and/or Closed by a particular user?

I want to create a list of issues that were Resolved or Closed by a particular user. This is different than searching for a list of issues that are currently in a resolved or closed state and are assigned to a particular user. I want to know WHO resolved the tickets. Any ideas?

6 answers

1 accepted

15 votes
Answer accepted

Thanks for the reply. I also figured it out this way:

status was Resolved by "user_name" before "2014-03-08" after "2014-03-02"

You can do this via JQL. Couple of examples below:

status changed to Closed by xyz
status changed to Resolved by xyz after -10d

If you are querying for yourself, you can substitute xyz with currentUser()

Thanks for the reply. I also figured it out this way:

status was Resolved by "user_name" before "2014-03-08" after "2014-03-02"

Hello All, I know this is an old thread, but I thought it might still work the same... but it does not. I receive an error when attempting to use "BY" and adding a user name.  It keep trying to fill in statuses for the BY variable and not usernames.

Screen Shot 2018-02-02 at 4.21.06 PM.png

I was able to get this to work in this format:


project = “IT Support” AND status WAS “Resolved” BY “xx.xxx@accc.com"

This didn't work for me.

any other ideas?

Hmm~  Try without the quotation on the Resolved


project = "IT Support" AND status was Resolved BY "usernamehere"

Also~ try typing it all out slowly and letting the smart query do its thing (all but the username part, which it doesn't seem to auto fill for me)

update to this specific queries using "username"

https://confluence.atlassian.com/cloud/blog/2018/06/say-goodbye-to-usernames-in-atlassian-cloud

looks like username has been done away with altogether.

I replaced email address where username goes and that worked for me. 

really like the option with

project = "IT Support" AND status was Resolved BY "usernamehere"

however, I'm afraid it won't be working for Next-Gen projects, unfortunately.. at least.

it doesn't on my end.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

Jira Cloud for Google Sheets: Automatically Refresh Your Data!

Remember that time you realized it was possible to refresh your Jira data in Google sheets with just one click? What if we told you that you can now get the latest data with no clicks at all?! Zero! ...

454 views 3 11
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