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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published yesterday in Marketplace Apps

Calling all developers––You're invited to Atlas Camp 2018

 Atlas Camp   is our developer event which will take place in Barcelona, Spain  from the 6th -7th of   September . This is a great opportunity to meet other developers and get n...

57 views 0 3
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