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 Oct 09, 2018 in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

391 views 6 0
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