JQL to Extract Status Change Date for Jira Projects

[Vaibhav Agarwal]

Hello - Need to get status change date for jira tickets/projects.

Example: What would be date for status change from "EC Review" to "To Do" , for all the jira's in a project.

Need assistance on JQL to fetch such data 

[Zoryana Bohutska _SaaSJet_]

Hi @Vaibhav Agarwal 

Also, you can consider Issue History. This add-on lets you monitor time and dates of all updates that have been made in issues, including status changing.

Moreover, you will be able to view updates made by each user from the account.

With data export, you can dive deeply into analyses for better business decisions. 

Hope it will be useful for you

[Emre Toptancı _OBSS_]

Hello @Vaibhav Agarwal ,

As far as I understand, you want to see a list of issues with workflow status names as columns and the dates of entry to those statuses as values. I am afraid Jira does not provide this information out-of-the-box.

You have a few options but first, two things to note here: First, an issue might visit the same status more than once so those dates will be different. Second, for some cases using the status entry date makes sense, for other cases using status exit date makes more sense.

As a first option, you can create custom fields for each status date that you are interested in and use one of the post functions (provided by various apps) to copy the current date to appropriate date field. This will get you a solution but you need to implement this in every transition and actually it is hard to maintain.

I was gonna offer getting the data from the database directly but you are using Jira Cloud so you do not have access to Jira DB.

Finally, if you are interested in a ready built solution, our team at OBSS built Time in Status app for this need. It is available for Jira Server, Cloud and Data Center.

The app contains 4 different date reports that show first/last entry/exit dates for all statuses.

Time in Status also gives you reports that show how much time each issue spent on each status or assigned to each assignee. You can calculate averages and sums of those durations grouped by issue fields you select. (For example see the average InProgress time per project and per issuetype). You can also combine statuses into consolidated columns to see metrics like Cycle Time or Lead Time.

Using Time in Status you can:

• See how much time each issue spent on each status, assignee, user group and also see dates of status transitions.
• Calculate averages and sums of those durations grouped by issue fields you select. (For example see average InProgress time per project and per issuetype.)
• Define your custom calendars for more accurate duration reporting.
• Export your data as XLS, XLSX or CSV.
• Access data via REST API.
• See Time in Status data and charts for each issue as a tab on issue view screen.

https://marketplace.atlassian.com/1211756

EmreT

[Wolfgang Landes]

Hi,
Please look into this docu under "changed" for status changed operator.
https://support.atlassian.com/jira-core-cloud/docs/advanced-search-reference-jql-operators/

This JQL Query will give you all issues that changed the status with the mentioned transition starting from this year.
 
"status changed from "EC Review" to "To Do" during ("2020/01/01", now())"

Or do you rather want to have statistics on numbers of status changes per day? In that case you would need to look into dashboard gadgets and reports.