nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL query on statuscategories and statuscategorydatechanged

Former user

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!

Accepted answers

Trudy P Claspill

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.

All comments

Trudy P Claspill

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.

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.

epic created and transitioned.png

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.

status entrance report jira.png

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

Former user

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

Former user

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud