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 Sign up to answer
Community showcase
Posted Monday in Confluence

Organizing your space just got easier - Page Tree Drag & Drop is here

Hi Community! I’m Elaine, Confluence Product Manager. You may have read my earlier post about page tree in space navigation sidebar. I'm excited to share another improvement that helps you organize ...

103 views 3 4
Join discussion

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