Change Security Level of many Issues at one time

Is it possible to change the security level of all issues in one Project which resolution date is older than today at one time.

For example with SQL in the MySQL database. Which field is used for defining the security level.

2 answers

1 accepted

There are two possibilities. One is filtering the issues and bulk-cange them. There is the problem that you can change only 1000 issues at one time and the "Last Changed" will be changed.

The second way is to go to the Database, backup it and go to the table "jiraissue". In the field "SECURITY" is the security level defined. By changig it there the "Last Changed" date will not be affected.

But as the atlassian Support says : we do not recommend making any direct changes through the database

So be careful :)

0 vote

Define a filter which finds the issues you are interested in changing (e.g. resolution date < -1d) and bulk-edit them.

If you try to do this in the database, you'll need to stop Jira, backup the database, prove the restoration works, apply the changes, restart Jira and reindex it.

The Problem with Bulk-Changes is that the "last changed" date will be replaced. Is there a possibility that the date will not be changed. I would like to avoid it.

Suggest an answer

Log in or Join to answer
Community showcase
Maarten Cautreels
Posted Thursday in Off-topic

Friday Fun: What's your favourite beer/drink

As a Belgian, beer-lover and home brewer, beer is one of my great passions. I love the fact that with just a few ingredients (usually just water, hop and malt) you can create so many different tastes...

288 views 38 9
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot