change Notification Scheme and permissions scheme from default to specific one

Question

Hello Community,

is there any PGSQL query that you have used to change all projects which are using default permissions scheme, software schemes and notification schemes to another one. I need some PGSQL query to be able to do that so i can change and import into another instance.

please advise. thank you.

Radek Dostál · Answer

Most of what you're looking for is in nodeassociation table.

I'd post a code block, but the code blocks have been broken here for as long as I can remember, so I may or may not edit it in.

If it's not there, then default scheme is assumed. Issue Type scheme isn't there because it's in custom field context format, not as a "scheme" per se. But permission schemes, notification schemes, those should either be there, or not.

You would generally be better off doing this through either REST or Groovy. DB is.. questionable, but that's the table I'd look at if I had to.

What you should also keep in mind is that project schemes are cached. If you switch it in DB, and leave the cache stale, you will either produce corrupt data, or just some trippy behaviour if lucky enough. So if you have to, I'd suggest to make sure Jira is off.

And of course, it wouldn't be a community post if I didn't say it, make backups, but preferably look for alternatives. Permission/notification schemes should be fine, but anything else you touch in there and it isn't compatible is not going to be Jira's fault.

best I can do, code block is unusable 90% of the time

Om Joshi · Answer

what is the way to us REST API to do the bulk change for this? is there a way to achieve this using UI?

Anahit Sukiasyan · Answer

Dear @Om Joshi

Welcome to the community!

As I know, using PostgreSQL to modify Jira project schemes directly in the database is a high-risk operation and not officially recommended by Atlassian. Direct database modifications can lead to data corruption, unsupported states, or issues during Jira upgrades. 
Atlassian recommends making such changes through the Jira UI or REST API.