statusCategoryChanged is not helpful as it restricts to query the date when a status changed

Question

In Cloud Jira, we do not have a built in mechanism to query or view as a list the date when the status transitioned.

statusCategoryChanged is very restrictive and is not helpful. It forces to categorize the status in general category of open, in progress and closed.

Could you please bring back the field that captures the Status Transition Date.

Thanks!

Bartek Szajkowski _ Orbiscend OU · Answer

Hello @Ashima Gupta

Thanks for your request.

If you are open for third-party app, I would like to recommend to check JQL Argon app JQL ARGON Powerful Search

ARGON's transitionedBy JQL function lets you query issues by the exact status they transitioned to and when — down to a specific date/time window, with optional filtering by who made the transition.

Example 1 — find all issues that moved to "In Review" in Q1 2024:

issue in transitionedBy("project = DEV", "In Review", "2024/01/01", "2024/03/31")

Example 2 — find issues moved to "Done" by a specific person:

issue in transitionedBy("project = DEV", "Done", "2024/01/01", "2024/12/31", "jsmith")

You get full control over any named status (not just open/in-progress/closed), and you can narrow by date range and responsible user — something native Jira JQL simply doesn't support.

I hope my answer will be useful for you.

Greetings
Bartek from Orbiscend OU (JQL Argon app provider)

John Funk · Answer

Hi Ashima,

There are a variety of ways to do this. One is to get an Atlassian Marketplace app that tracks that very well. The other is to create a custom field and populate it with an Automation rule.

Philipp Sendek _catworkx_ · Answer

Hi @Ashima Gupta ,

I understand your frustration. While it might not solve your exact problem, the following article might be able to give you a few ideas how to work around this problem and find a solution that helps you track what you are looking for on a regular basis: https://community.atlassian.com/forums/App-Central-articles/Jira-Status-Transitions-How-to-Track-Them-Easily/ba-p/3093101

Greetings
Philipp