The problem is that because JIRA supports many types of user directory, it has a very simple approach to groups - it uses the group name as the key. It used to do this with users too, until VERY recently (logon = key in that case), and it's a nightmare to refactor the whole system to use a key instead of the group name.
That's why you can't rename them - the name is the key, so you need to go through *everywhere* the name *might* have been used to check and update it.
Off the top of my head, you *might* have used a group name in
- Project notifications
- Permissions
- Roles in projects (ok, I'm certain you've done this one)
- Group pickers
- JQL
- Gadget definitions
- Report, board, dashboard and filter shares
- Workflow functions (stored as xml, NOT in discrete fields, so you can't search and replace SQL, you need a full blown xpath editor)
- As for addons, well, you're on your own there - that's a complete free-for-all. If you've got Tempo or one of the other big ones that uses groups, you'll have to work out all their storage etc yourself.
I'm afraid you've been lumbered with a potentially vast painful job here, and SQL simply isn't the answer unless you can establish exactly how they've been used.
Your only option really is what Joe said (as I typed this up...)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.