JQL query on statuscategories and statuscategorydatechanged

[charlotte]

Hello,
I'm trying to set-up a JQL query (with not a lot of luck) that can show me when an epic's status category changed. I want to know what date an epic was created, the date when it transitioned to in progress and then the date when it transitioned to done/resolved.

I want to get a gauge for how long it took for something to be delivered. There might be an easier way - but interested in your thoughts.

Thanks!

[Trudy Claspill · Accepted solution]

Hello @charlotte 

StatusCategory allows you to query for issues based on the Status Category to which the issue's current status belongs. 

StatusCategoryChanged records only the last time a status change resulted in a change of the Status Category of an issue.

These fields don't give you a history of Status Category changes.

Natively Jira does not provide a JQL method to query to get the dates/times of every Status and Status Category change.

To get that information you would need to look for a third party app from the Atlassian Marketplace.

You can get the date/time an issue was Created from the Created field, and the date/time the Resolution was set (normally set when an issue transitions to a done status) is recorded in the Resolved (or ResolvedDate) field.

You would set up an Automation Rule to record in a custom field of your creation the date an issue transitions to an In Progress status, but that information is not recorded in a field that is available to display or query, natively, without you adding that automation.

[charlotte]

Thanks Trudy, that's helpful and definitely as I went through the process, came to the same conclusion around the Status Category Changed date.

I like your idea around a custom field and automation on the transition - I might look into that and see what I can come up with. Thanks for coming back to me, I appreciate it.

[Yuliia_Borivets__SaaSJet_]

Hi @charlotte 

For the case you described, I would like to suggest Issue History for Jira from my team. It helps to record all changes to any standard/custom issue fields. You will get information about what was changed, when, and by which user.

I made this screenshot to show an example of epic changes: green dot marks the date of creation (New), and then you can see dates of transition to "In progress" and "Done". Also, there is a filter to select the status transition you want to display.

Additionally, you can check Time in Status for Jira app. There you can get a specific time an epic spent in each status and also the status entrance date report.

Both apps are developed by my team and have free 30-day trials. Let me know if you have any questions.

[charlotte]

Thanks Yuliia, let me check that out to see if it does what I'm looking for. I appreciate your response.