JQL to find the assignee during a specific transition?

Question

We are trying to determine who the the developer that did the work on this specific issue* Issue starts assigned to Amy with status of New
* issue progresses to Open with the assignee of Belinda
* Belinda progresses issue to In Progress (Assignee remains Belinda)
* Belinda finishes her work and assigns to Candice for QA

I want a query for "list all issues that progressed from Open to In Progress during this time period"

here's the trick: I need to know who was the assignee during that progression (in this case, it was Belinda... I don't need to know about Amy or Candice)

Or, is there another approach that I am missing?

Thank you for your assistance

Tiffany Lirones · Answer

Hello - I have a similar need.  Assignee changes depending on the status.  I want to run a report that pulls who the assignee WAS when the issue was in "Code Review" status.  Is this possible?  I don't want to know current assignee, or initial assignee - but specifically, the assignee at the time the issue was in the Code Review status.

This works, if I run the report for each individual working on this project, but I want a report that tells me the assignee during the specific status, so I don't have to run this report for each individual:

project in (MDO, MFE, CET) AND status changed from "Code Review" after startOfDay(-7d) by insertassigneehere

markmiddleton · Answer

correct.  we have some 3000 issues a week, and trying to run reports to capture data about the production.  I believe the "by belinda" method above might get me a lot closer - much appreciated!

Sam Hall_h1otcf · Answer

p.s. I'm assuming you are wanting to look at many issues, so it's impractical just to look at the "History" or "Activity" tabs on the issue(s)?