Change the resolution date to the date of the status category change.

Nathália Agostini
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 18, 2023

There was a recent workflow change on the board, but they forgot to configure the resolution for the "done" status. I made the resolution change, but all the issues that were completed before changing the resolution ended up with "unresolved" resolution. I managed to change the resolution of these issues to "done" through automation.
The issue now is that the "resolution date" shows the date of the automation rather than the date when the card was completed on the board.
How can I change the resolution date to copy the date of the status category change?

2 answers

1 accepted

1 vote
Answer accepted
Fernando Eugênio da Silva
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 18, 2023

@Nathália Agostini , Welcome to the Atlassian Community!

You can change the issue resolution date by performing an Import CSV.

The steps are:
1: Make a filter in Jira and export the issues for which you want to change the resolution date in Jira to a CSV.
2: In this spreadsheet, adjust the date and time you want to apply the resolution date
3: Make a CSV import into Jira with the updated resolution date data.

The main column information you need to have in the CSV is:

Issue Key, Issue Summary, Resolution, Resolved Date

This is sufficient and mandatory information to retroactively adjust the resolved date via CSV.

You can know about Import CSV in Jira by here: Import data from a CSV file | Atlassian Support

Let me know if you have questions.

Rich Bloch
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 15, 2024

@Fernando Eugênio da Silva , to follow up on your solution, while I was able to generate an appropriate CSV file, in my case I needed to set a new Resolved Date. However, when attempting to assign the new Resolved Date field in the CSV file to the ticket about to be imported, the assignment option is not available in the droplist. This is true also for the Create Date field. All other fields appear to be available. 

From this observation, I'd suspect that both Create Date and Resolved Date are either exempt from change (as part of this CSV import workflow), or there's another problem that I haven't yet identified. BTW, I'm using Jira Cloud (100245).

Thanks for any insight and suggestions. 

Fernando Eugênio da Silva
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 15, 2024

Hey @Rich Bloch 

It is entirely possible to change the creation date or resolved date via import CSV.

What you need to consider is making this update via 'Import CSV' in the Jira global interface.

Click on the gear in the upper right corner > Click on 'System' > Click on 'External System Import' > Follow the remaining CSV mapping steps.

This interface opens all available CSV import features into Jira. I just tried to do it and it works as well.

Import Details

Screenshot_168.png

Issue details:

Captura de tela 2024-01-15 234843.png

Hope this helps you.

Like # people like this
Bjorn Bartlett
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 17, 2024

Thank you @Fernando Eugênio da Silva , your post finally clarified the solution to this problem for me and I can finally see an accurate 'Created vs Resolved' chart.

Widerlani Campos July 26, 2024

For those of you that did the export+import, did all go OK? I want to do it in my project, but I'm afraid that might break something. Is there any risk with that approach? Could there be some data loss in the issues?

Matthew Mallard October 30, 2024

Tested on v9.4.3 and this does NOT work.

0 votes
Widerlani Campos July 26, 2024

edit: sorry I wrote in the wrong place

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
AUG Leaders

Atlassian Community Events