Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Extract the date of a specific status change from the history

Konstantin Löscher March 4, 2025 edited

 

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

 

Screenshot 2025-03-04 140957.png

 

5 answers

1 vote
Ayça Erdem_OBSS_
Atlassian Partner
March 6, 2025

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.

last_transition_date.png

 

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

1 vote
Hannes Obweger - JXL for Jira
Atlassian Partner
March 5, 2025

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:

date-of-transition.gif

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

0 votes
Petru Simion _Simitech Ltd__
Atlassian Partner
10 hours ago

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.

issue_history_search_result_filter_only_status.png

 

Regards, 

 

Petru

0 votes
Rahul_RVS
Atlassian Partner
March 6, 2025

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

TIS - Status Transition Details.PNG

0 votes
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 4, 2025

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 March 4, 2025

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 4, 2025

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 March 4, 2025

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

Yuliia_Borivets__SaaSJet_
Atlassian Partner
March 4, 2025

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:

in progress - done transitions.gif

More examples here: Status transition history for multiple Jira issues

Like 2 people like this
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 6, 2025

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
atlassian, team '25, conference, certifications, bootcamps, training experience, anaheim ca,

Want to make the most of Team ‘25?

Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.

Learn more
AUG Leaders

Upcoming Jira Events