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?
@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.
@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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Issue details:
Hope this helps you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.