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; } } }

Extract the date of a specific status change from the history

Konstantin Löscher

Hello,

I want to transfer the status change to closed (see picture) and its date into a variable, but unfortunately when I output the variable there is no value in it.

Unfortunately, this date is also not the last entry, it is always really in one place in the history, the last entry with closed must then be found and then the date extracted into a variable.

I have tried the following command:

Maybe someone can help me?

Best regards

Screenshot 2025-03-04 140957.png

Accepted answers

All comments

Jack Brickey

Hi @Konstantin Löscher , if the historical date is the date when the issue is closed could you not use Resolution date?

Konstantin Löscher

unfortunately we skipped the status done for a while and made it closed directly for this reason there is no date in done

Jack Brickey

if you want to leverage a specific date of transition then you would need to create a custom field and record that date when the transition occurs using automation. There is no way to extract it from the history. At least I have never found a way of doing so. As I recall, there are third-party solutions if that is something you can consider.

Konstantin Löscher

Ok thanks for your answer what is the name of the third party solution

Hannes Obweger - JXL for Jira

Hi @Konstantin Löscher,

an issue's status changes are captured in an issue's issue history, which you can access from the issue view in Jira or via Jira's REST API.

Alternatively, there's a number of apps available on the Atlassian Marketplace that can help extracting this data for you. 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 long list of so-called history columns that aren't natively available, including the date/time of transition to [status], time in [status], time between [status] and [status], and many, many more.

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 Excel or CSV in just two clicks.

Any questions just let me know,

Best,

Hannes

Ayça Erdem_OBSS_

Hello @Konstantin Löscher

An issue's status transitions are recorded in its history, which you can view directly from the issue screen in Jira or retrieve programmatically using Jira's REST API.

Another solution is Timepiece - Time in Status for Jira , the oldest and leading Time in Status app in Atlassian Marketplace, which is built by my team at OBSS. It is available for both Jira Cloud, and Data Center.

You can use the date-based reports to see the transition dates from/to a status. In the screenshot below, you can see the transition(closed) dates of each issue. I think this report will be spot on for your needs.

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well.

Timepiece reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs. All these options can provide both calculated data tables and charts. The app has a REST API so you can get the reports from Jira UI or via REST. Also you can export the reports in to various formats easily.

Visit Timepiece - Time in Status for Jira to explore how our JIRA add-on can revolutionize your metrics measurement process.

If you have any questions, let me know!

Ayça

Rahul_RVS

Hi @Konstantin Löscher

As suggested by everyone a mktplace app can help here. If you are open to try out one, take a look at

Time in Status Reports

With this app you generate time in each workflow status for multiple issues with multiple filter and grouping options. You can also extract trends analysis and add that as a dashboard gadget too.

The Status transition details report can help with your use case. It shows the date when an issue transitioned from a state to another and who changes the state.