How can I bulk un-archive Jira issues.

[user1647473884182]

We generate thousands of Jira issues each month.

We archive issues which are very old to reduce the size of the database/index and improve performance.

Occasionally, we want to un-archive >1,000 issues but currently I do not see any way to do this as a bulk operation (i.e. not individually). I can generate the list if issues to un-archive (export to CSV and select from there).

It seems that Atlassian may have not seen archiving the way customers will use it and left out bulk un-archiving from the functionality.

Does anyone have a method to bulk un-archive?

Alternatively, can you bulk update archived issues via CSV import? (Probably not but if you don't ask..., plus it might be a way out of this for jira-system-administrators).

[Mohamed Benziane · Accepted solution]

Hi,

There is no bulk option for this, here a feature request you can vote for :

https://jira.atlassian.com/browse/JRASERVER-71156?error=login_required&error_description=Login+required&state=b318198a-090b-4373-bd5e-29d18a0dd9f3

You can try to do it with the REST API

https://docs.atlassian.com/software/jira/docs/api/REST/8.16.2/#api/2/issue-restoreIssue

Create a JQL that find all archive issue you want to restore and create a loop to restore them with the API

[Steve Letch]

A much easier way to do this is bulk change the DB, I know Atlassian advise against it, but I just bulk restored 1200 tickets of a specific project and issue type by just setting Archived to N and reindexing the instance.

Example

UPDATE public.jiraissue

SET archived='N'

where project = '14301' and issuetype = '10205' and archived = 'Y'