Status change date field

Question

I am exporting Jira tickets via REST API.

I need to find tickets that have been changed to Staus: Delivered in the past 7 days.

In Jira, I can easily via a filter:

status =Delivered AND status changed AFTER -7d

I can find the StatusCategoryChangeDate field, but what is the "Status change date" filed called?

I cannot locate the field that tracks changes to the STATUS, NOT the STATUS CATEGORY.

I cannot simply use the "Updated date" field, as tickets do get modified after changing to Status: Delivered.

Gizem Gökçe (OBSS) · Answer

Hello @Richard Cieslik ,

Welcome to the community!

Tracking specific status change dates, like when tickets moved to “Delivered” in the past 7 days, isn’t possible with native Jira fields, as there’s no dedicated "Status Change Date" field. Status changes are only stored in the issue history, and native Jira doesn’t allow these dates to be shown directly in filter results.

Solution with Timepiece:
For a straightforward way to track and report on status changes, I recommend Timepiece - Time in Status for Jira, the oldest and leading 'Time in Status' app in the Atlassian Marketplace, which is developed by my team at OBSS.

With Timepiece, you can:

* Generate a Date Report to pinpoint exactly when each issue transitioned to “Delivered.”
* Easily filter for items that have been updated within the last 7 days
* In addition if you need you can add this report to your Jira dashboard using the Timepiece Dashboard Gadget for ongoing visibility and easy access. Or you can this data through Timepiece’s REST API, allowing you to pull status change information programmatically for further processing or integration with other systems.

Timepiece is available for both Jira Cloud and Data Center. Let me know if you’d like help setting up this report or need more information! If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.

Best regards,
Gizem

Rahul_RVS · Answer

Hi @Richard Cieslik

Welcome to the community !!

As suggested by everyone, a mktplace app can help here. if you would be interested in the same, please try out an add-on we have developed for the same use case.

Time in Status Reports

The app has more than 20+ reports to meet a variety of use cases. For your requirement, the report below can help track the issues with the status date change details.

More details here

Disclaimer : I work for the vendor who built this app

Hannes Obweger - JXL for Jira · Answer

Hi @Richard Cieslik

as already suggested, there is no status change field in Jira. In native Jira, the easiest might be to set up an Automation rule and write the status change date to a custom field.

Alternatively, if you're open to solutions from the Atlassian Marketplace, you'll have options available.

E.g., you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called history columns that aren’t natively available, including the date of status change.

This is how it looks in action:

As you can see above, you can easily sort and filter by your history columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Of course, you can also export your data to XSLX (e.g., Excel or Google Sheets) or CSV in just two clicks.

Any questions just let me know,

Best,

Hannes