You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
How do I know the name of the field that stores the date the problem was moved to the next column.
The issue is in the "ready for development" column and has been moved to "in development". I need to know which field holds that date.
If I look at the problem's movement history, I can find the information, but I need to find out the name of the field to put in my query.
I want to build a split cumulative flow diagram divided into parts.
Hi Max, thanks for the reply.
I believed that it would be possible to find the field that is recorded with the information highlighted in yellow.
But from what I was able to identify, this highlighted information is the result of an account based on the creation date plus the time that the problem spent in the previous status. Can you tell me if this understanding is correct?
Hey Alvaro, again. It's not a field in Jira. Feel free to extract the issue's history through the REST API. That will return the full changelog. The timestamp is the exact point in time when the edit happened. Afaik, they do not relate to each other or are not derived from each other at all in Jira. So your understanding is not correct. Your screenshot also doesn't support your assumption, as an exact time for the transition is given. Or am I missing something?
Hi @Alvaro Correa de Frederico
Not sure if this can be achieved out of the box.
If you would be interested in a mktplace app, you can try our addon:
The add-on provides the issue transition dates report which can meet your requirement.
Also there are 20+ reports in the app which help to meet a wide range of use cases.
Do try it out.
Disclaimer : I work for RVS, the vendor for this app
Hi @Alvaro Correa de Frederico
You can try Status Time Reports app developed by our team. It mainly provides reports and gadgets based on how much time passed in each status.
Here is the online demo link, you can see it in action and try without installing the app. For your case, you can have a look at Status Count And Entry Dates report.
If you are looking for a free solution, you can try the limited version Status Time Free.
Hope it helps.
Hello @Alvaro Correa de Frederico
I guess, you can try one of the fastest and easiest ways - Time in Status for Jira Cloud and its Status Entrance Date report. It shows the date an issue moves to each of your workflow statuses.
Also, you can export it to CSV or XLSX files for further analysis or share with your colleagues or other analytical systems.
This add-on is developed by my SaaSJet team. Please, let me know if you have any questions.
Hope it helps