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:

{{#changelog.status.reverse}} {{#if(toString.equals(“Closed”))}} {{created}} {{/}} {{/}}

Maybe someone can help me?

Best regards

[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

[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

[Petru Simion _Simitech Ltd__]

Hi @Konstantin Löscher ,

If you are open to using apps you can use Issue History Dashboard for Jira , an app released by our company.

You can filter for Field Updated - Status and this will only return the status related history changes.

Field Date of Change displays the date the change took place.

Regards, 

Petru

[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.

More details here.

Disclaimer : I am part of the app team for this add-on

[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

[Yuliia_Borivets__SaaSJet_]

Hi @Konstantin Löscher 

If you need specific status changes + date of change, you can check out Issue History for Jira from my team. It allows filtering by specific transition like In Progress-Done:

More examples here: Status transition history for multiple Jira issues

[Jack Brickey]

Hi @Konstantin Löscher , as you can see there are quite a few option to choose from including an OOTB method. Hopefully, you can meet your needs but let me know if you have further questions.