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

[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

[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