How to migrate groups to roles in comment visibility?

Question

I'm trying to get rid of groups in my Jira instance, replacing them with project roles. I'm currently stuck with a group that has been used to reduce the visibility of some issues. If I try to delete the group Jira warns me that:

There are comments that only this group can see.

Deleting this group would make those comments invisible.

and gives me the possibility to move those comments to another group (!). Is there any way out? for example, is there a way to select those comments so that I can change the visibility manually to a role?

Yilin · Accepted Answer

That is not possible, but you can remove the all group restirction by running the following query:

update jiraaction set actionlevel=NULL where actionlevel is not NULL;

If you wish to direct switch the group to role, you probably need to pick up the project role id in the table projectrole then add it in the same table.

After that you will need to restart JIRA and reindex the whole instance.