Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How do I access the status transition time (Date/Time in to and out of status)

Neil Zaccari April 19, 2022

For each status in my workflow, how do I get the time it move into a status and the the time that it moved out of that status?

1 answer

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 19, 2022

Welcome to the Atlassian Community!

You will need to read the issue history - that contains "status changed from X to Y" records with date and time stamps on them.

Neil Zaccari April 19, 2022

When I export the issues, there isn't a column with that data in it

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 19, 2022

No, it's not a field, it's a line in the history, which isn't part of the Jira exports to CSV/Spreadsheet. 

You'll need to read the history another way - either a custom field that can read the history and expose it, or creating a report that can read the history.

Neil Zaccari April 20, 2022

Ok, sounds like I need a custom field that populates the date and time when an issue transitions IN TO a Status and another custom field the populates the date and time when it transitions out of a status.

Suggest an answer

Log in or Sign up to answer