Timestamp for Issue Resolved?

Christopher Johnston March 7, 2025

I'm trying to find a more recent answer to the question of a system timestamp for when an issue is resolved (Done, Cancelled, etc) for Jira Cloud. Does anyone have a method to do this as I'd like to use that date in a filter. Thanks.

2 answers

1 accepted

0 votes
Answer accepted
Jovin
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 7, 2025

Hey @Christopher Johnston 

This can be done with the below JQL:

resolved = 2025-03-07

This will show all issues resolved on the 7th of March 2025.

Is this what you mean? 

Christopher Johnston March 7, 2025

Thanks for the response. I'm looking for the date when an item transitioned to Done or Cancelled. I'm hoping there is a field that automatically captures this. If not, I'm going to just create an automation to do this.

Christopher Johnston March 7, 2025

My bad, you actually answered my question. Seems inclusion of Resolved and a time range of between X date and [blank] does this for me. Thanks for the response.

Christopher Johnston March 7, 2025

My bad, turns out this isn't always going to provide information. I'm not 100% sure why the field doesn't pupulate sometimes. In the meantime, I've just written an automation so that it puts the date when something moved into a resolved status and the value goes into a net new custom view-only field.

0 votes
Petru Simion _Simitech Ltd__
Atlassian Partner
March 8, 2025

Hi @Christopher Johnston , 

 

Good practice is to set the Resolution field in the workflow any time the issue is transitioned into  a terminal status such as: Done, or Cancelled.

The set resolution triggers some reports to know the issue is indeed done or cancelled.

The information of when the ticket is transitioned into a terminal status is captured in issue history. You can either manually search each issue, or extract the data using REST calls, which will return the data in JSON format that you later need to parse.

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

Filter by Field Updated - Resolution.

Field Date of Change displays the date each issue was transitioned into the status that changed the resolution.

 

issue_history_result_filter_only_resolution.png

 

Regards, 

 

Petru

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events