nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to (bulk) change resolution date (instead of just status) of already closed tickets?

Cynthia van den Ham-Hilman

I noticed the resolution status was not being updated by closing issues. Have fixed this by adding an extra post function to the transitions leading up to 'done' in my current workflows. It works well now.

However, before noticing and fixing the problem, we have been closing issues without changing the resolution for over two months. I can change the resolution status in bulk, but I cannot find how to also change the resolution date of the already closed issues. The reason I want to change this is, we use the dashboard gadget "Created vs. resolved chart", which will now display all the closed issues that spread out over JAN/FEB/MAR on this month.

Therefore the question: How can I (preferably in bulk) change the resolution date of closed issues?

Accepted answers

Gaston Valente_dzz4x1

Hi,

If you need to simply set the resolution date of these issue to the current date you can create a temporary transition that sets the resolution field from any status to any status and then do a bulk transition.

If you need to set the the resolution date to a past date it's more complex, here you can find some answers:

Is there a way to change the "Resolution Date" in Jira?

https://answers.atlassian.com/questions/196334

https://answers.atlassian.com/questions/62626

All comments

Gaston Valente_dzz4x1

Hi,

If you need to set the the resolution date to a past date it's more complex, here you can find some answers:

Is there a way to change the "Resolution Date" in Jira?

https://answers.atlassian.com/questions/196334

https://answers.atlassian.com/questions/62626

Brody

Hi Gaston,

It appears that all 3 of these links are now bad, do you have any other references for editing the resolution date to a past date?

George Mihailoff

For others who stumbled at this, try our free addon (Quantify) that has a special "resolution checker" tool. Because we deal with things like time in status, throughput and other Kanban metrics we have the data to fix this. The process looks like this:

1. You do a JQL-powered search

2. Select issues with the suggested resolution dates

3. Export this as CSV file

4. Import back to Jira to update fields

And yes, this is done in bulk 😉

Hector Herrera

I was able to update Resolution, Date Resolved, and Status with the following procedure. The same procedure allows to update almost all fields available in JIRA, so you can choose which ones to map.

Export the issues to update as Export Excel CSV (all fields)
Open CSV file and edit the fields that you want to update (e.g. Resolved, Resolution, Status). Make sure of setting dates with a date format that matches the one in JIRA (e.g. MM/dd/yyyy hh:mm AM/PM -> MM/dd/yyyy hh:mm a)
Go to to the JIRA Import Wizard (External System Import)
Select the button "None of these"
Choose the file that you prepared in step 2, click Next
Select the target project in Import to Project, click Next
Set the fields to update including Issue Key and Summary. Click Next.
Begin the import

Michael Moss_yrw16s

I have not been able to replicate this process.

Bastien Lespinasse

Hello Hector and Michael,

I was able to replicate the process you described for Jira Cloud, but it did not work for Jira Server and Data Center.

To my understanding, the resolution date is not stored as a field in Jira Server and DC, but it is for Jira Cloud.

Michiel Schuijer_yj4jdb

Hi, @Bastien Lespinasse

This does work for Jira Server/DC, but it is required to also add the resolution field in the CSV, in addition to the date.

It works on our Jira DC version 8.22.6

AP_ij8hk4

The challenge here is when the tickets are tied to a Workflow which doesn't allow you to transition the status out and back to some configured 'Completed' status. It's super convenient when searching for outstanding tickets using JQL to find all of those without an resolution (ie 'resolution = Unresolved', or conversely 'resolution != Unresolved' for those that are completed). So how to fix?

The easy thing to do (only done this in cloud) to fix this is via a Jira automation:

Create a new Jira automation
Set the trigger to be manual and accept user input with a dropdown question
1. Optionally limit use to the desired user group(s)
Include the desired resolution system names in the options.
Add an 'Edit Issue' action and choose 'Resolution (System)' from the list.
Type the smart value name of user input field as the value as opposed to choosing one of the options. example:
1. ```
{{userInputs.resolution}}
```

Screenshot 2024-01-10 at 5.24.58 PM.png

Now when you find these tickets you can just run this automation!

Michael Alabastro

Comment from Dario B in this thread helped:

Can't update resolve date

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-service-desk

jira-service-desk-cloud