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
Accepted answer

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 Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,740 views 17 21
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