Query to find closed by who

By mistake, while assigning Story workflow to Tasks, I have mapped Confirmed --> Closed. This was an incorrect mapping. Result: Issues in Confirmed status (and users were still working on them) are now showing as Closed. Is there a query I can use to find out the issues closed by my userid for this project over the last 3 days?

Any help would be greatly appreciated. Thanks.

3 answers

2 votes

Try this:

status changed from Confirmed to Closed by xyz after -3d

Hi this is not an answer but it's a question due of I don't see an answer to this question "query-to-find-closed-by-who"  and because I saw the answer of Jobin and it doesn't work on my Jira.  Please I need to make queries by "closed by" column but I don't see this field on my Jira.


closedby query.PNG


@Jobin Kuruvilla [Go2Group]  this last answer confuses me because you suggested in this page "status changed from Confirmed to Closed by xyz after -3d", but anyway, what's the exact query to find "closed by" list.  I want to find all the items closed by me with an specific word


@Jobin Kuruvilla [Go2Group] I don't know what happened with the screenshot, did Jira system deleted it by accident? anyway, here is the link of the same image. http://content.screencast.com/users/Jill-Kimbia/folders/Default/media/2e34ed2e-3e26-43a3-ae29-36c249d9a6ce/closedby%20query.PNG and I still don't believe this answer of yours include the query I want to make, I need closed by me not status1 to status2

You cannot write just 'closed by'. it will be 'status changed from status1 to status2' or 'status changed to finalStatus'. Replaces status1, status2, finalStatus etc with valid statuses.

Closed is a valid status and so you can use Closed in the example. But it should come after "status changed to". I don't see that part in the screenshot. Why did you take it off?

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Feb 15, 2018 in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

1,111 views 6 19
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot