JQL history query

I am trying to review the work done by people over the week, but from the QA side, the reporter and developer may have nothing to do with who reviewed the issue as being fixed.

Is there any way I can query on the information presented in the history tab?

1 answer

1 accepted

0 votes

Try something like this:

status changed to Fixed by john

2 dimentional gadget is a different thing but you can include the period in the above query:

status changed to Fixed by john during (startdate, enddate)


status changed to Fixed by john after -2w


You can also have multiple people:

status changed to Fixed by (john, obama) during (startdate, enddate)

wow that is close, unfortunately I would have to do a query for each employee.

I am really trying to get a two dimensional gaget that would show me the count of issues that each user updated during "y" period of time.


It is an answer and a correct one. Just not getting me what I am trying to do. Even after doing a query useing the By, there still would be no way to sort on the user that made a change. So even if I put the whole team in the by, I would not be able to break it back out easily.

(I have only been working with this for a couple of weeks so I am still learning the functionality / limitations.)

I agree. If you are planning to sort only based on reporter/assignee/some other field on the ticket, you can do that for the above filters itself using the 2 dimensional filter gadget. But you won't be able to do that for the person who change it to Fixed status unless that is captured in a user custom field during the workflow tranistion.

Lot of people do it by capturing that in a user customfield.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,006 views 12 18
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
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