Migrate filters of Particular Users from Server to Cloud
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
The following article provides details on how to migrate filters of specific users from server to Cloud.
Solution
Overview
Starting from JCMA 1.10.0, our developers have introduced a feature that allows for the migration of boards and filters using JCMA itself. However, if a customer wishes to migrate filters for a specific user, there is currently no direct method to do so from server to cloud.
The following steps will aid in migrating the filter of a particular user from server to cloud:
Workaround to migrate filters of a particular user
Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Identify all filters not owned by the specified user.
1select * from searchrequest where author not in ('specify_your_user')Remove filters that are not owned by the specified user.
1delete from searchrequest where author not in ('specify_your_user')Utilize API calls to delete filters as an alternative method https://docs.atlassian.com/software/jira/docs/api/REST/7.6.1/#api/2/filter-deleteFilter
Create a placeholder project on the Jira server, such as "Dummy 1".
Uninstall the currently installed Jira Cloud Migration Assistant from the Jira server.
Access the following URL:
1${Jira_URL}/secure/admin/jira/views/SiteDarkFeatures!default.jspaInput the following DarkFeature:
1 2com.atlassian.jira.migration.skip.app.outdated.check com.atlassian.jira.migration.export.all.filtersClick Add (no Jira restart is necessary).
Download JCMA 1.9.17 from the Marketplace
Navigate to Settings> Manage apps.
Select the Upload app.
Locate and upload the file to install this specific version.
Go to Settings > System.
In the left panel, locate the Import and Export category, and choose Migrate to cloud
Create a new migration Plan to migrate the dummy project which we created in Step 3
Initiate migration process for transferring filters associated with particular users
Remove the dark feature added in Step 6
By following the aforementioned steps, you will be able to successfully migrate filters associated with specific users.
Was this helpful?