Query that returns issues which transitioned between 2 states and which users did the transition

Question

I want to find out which users transitioned issues between two particular workflow states in a given time window. The closest I can get so far is this: project = AND status changed from "" to "" during (,) by This gives me all the tickets transitioned between those two states by a particular user. However, I want to mimic the effect of running this for every user of the that project without having to create a query for each user. The key seems to be the "BY" keyword/operator, however I can't find documentation on this in the JQL reference...

Zoryana Bohutska _SaaSJet_ · Answer

Also, you can consider Issue History add-on, which let you monitor all changes at Jira issues, including status to status transitions. And you will be able to view separately only updates made by each user.

Additionally you can export data about all status changes and then sort it by user name. So it the one place, you will get data about all users.

I hope it will be useful for you.
Regards

John Funk · Answer

Hi Tom,

You could try:

by membersOf(jira-users)

You could sub out jira-users for a particular group that is smaller, but it is still not going to show you the user name or ID.

But then you could add a gadget to a Dashboard that might show what you are looking for.

Save your filter first.

Then add the Two Dimensional Filter Statistics.

Choose Assignee for one of them.

But still not sure that will get you what you are looking for if the assignee is not that user.