Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

4 answers

2 accepted

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.

2020-10-06_10-48-58.jpg

1 vote
Answer accepted

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.

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.

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

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.

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".

0 votes
Jack Community Leader Sep 28, 2020

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.

OK. Thanks for your help

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

7,018 views 8 28
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you