Issue Report: Status Changes

[Karrie Dash]

I want to run a report that will be run every day that tells me which tickets went from 1) To Do to In Progress and 2) In Progress to In Review the day before, but will sort them by who the assignee was during the In Progress status.

[Alex Christensen · Accepted solution]

I don't know of a specific report to do this, but you can get this information via JQL:

status changed from "To Do" to "In Progress" on -1d AND status changed from "In Progress" to "In Review" on -1d ORDER BY assignee ASC

This query returns all issues which changed from To Do, In Progress, and In Review all in the same day. I can't tell if that's exactly what you need or if you need two separate lists, but hopefully this can get you started, at least.

[Karrie Dash]

That works for me! Thank you!

[Marcus Tezcan]

Hi,

Can anyone give me a bit more instructions on where and how I do this please?

I'm in Jira Cloud, Team Managed projects. Columns: Ready to Start, Blocked, In Progress, Ready For Review, Done

Thanks!