Filter to find when a summary was moved into a given status.

[Roger Hancock]

Looking for a way to find when a summary, the date, was moved into a given status?

[Bloompeak Support · Accepted solution]

Hi @Roger Hancock ,

If you want status transition dates of a bunch of issues as an excel-like report, you can try Status Time app developed by our team. It provides reports on how much time spent in each status as well as status entry dates and status transition count.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports(eg. average in progress time per project).

Here is the online demo link, you can see it in action and try. Hope it helps.

[Mariana_Pryshliak_Saasjet · Accepted solution]

hello @Roger Hancock 

Tap on the "history" button after opening the issue, and you'll get all the changelog. Including the date when a status has changed.

I hope it helps.

[robert.nadon]

JQL supports finding when a status has changed:

STATUS changed FROM Open TO "In Progress" ON 2020-09-21

Data and summary do not Move to given status.  

Once you have the set of issues from the JQL you can use column to select summary and date.

[Roger Hancock]

Could you show me an example of the search string I would use to get the data?

[robert.nadon]

You could literally put the exact string above.  You may want to include a project as well.  So go to Jira -> Issues.  Click Advanced for putting in a direct JQL and type something like this:

Project = ABC and STATUS changed FROM Open TO "In Progress" 

To get every issue in ABC that has ever changed from open to in progress.

[Roger Hancock]

Thanks. That helps me get the related items that meet the criteria. Is there a way to now show the date it moved From Status "A" to "B" even if the current status has moved on from status "B"? I can see the "Updated" date but that doesn't necessarily give me the date it was moved to status "B".

[Jack Brickey]

the only way (OOTB) to know the date when a transition occurred is to view the History or Transition tab in the view issue. You cannot construct a JQL that will return the date as a column in the resulting list.

[Roger Hancock]

OK. Thanks for your help