Status change date field

[Richard Cieslik]

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. 

[Trudy Claspill]

Hello @Richard Cieslik 

Welcome to the Atlassian community.

There is not a Status Change Date field.

Status changes are recorded in the issue history. With native Jira functionality there is not an option to show any particular specific status change Date as part of filter results.

If this is an ongoing need you could consider adding a custom date field and using Automation Rules or workflow transition options to update it each time a status change occurs.

If you are open to third party apps, there are apps that can provide more granular visibility into the status change history of issues.

[Rahul_RVS]

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]

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

[Yuliia_Borivets__SaaSJet_]

Hi @Richard Cieslik 

This post shows how to capture the "date of change" for statuses with Jira automation (option 2) and a plugin from my team (option 3):

How to capture the “date of change” for Jira issues

[Gizem Gökçe _OBSS_]

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:

1. Generate a Date Report to pinpoint exactly when each issue transitioned to “Delivered.”
2. Easily filter for items that have been updated within the last 7 days
3. 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

[Petru Simion _Simitech Ltd__]

Hi @Richard Cieslik 

You can use CIFJ - Issue History for Jira Dashboard, an app recently released by our company.

https://marketplace.atlassian.com/apps/1235591/cifj-issue-history-dashboard?hosting=cloud&tab=overview

You can filter for those issues where the Field Updated has the value Status.

You can also filter by Date of Change as well.

The Date of Change field will contain the data you are looking for.

You can filter more, or order in the table.

You can export your data to CSV for further analysis.