Migrate filters of Particular Users from Server to Cloud

Still need help?

The Atlassian Community is here for you.

Ask the community

Summary

The following article provides details on how to migrate filters of specific users from server to Cloud.

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.
  1. Identify all filters not owned by the specified user. 

    select * from searchrequest where author not in ('specify_your_user')
  2. Remove filters that are not owned by the specified user. 

    delete from searchrequest where author not in ('specify_your_user')
    1. 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 

  3. Create a placeholder project on the Jira server, such as "Dummy 1".

  4. Uninstall the currently installed Jira Cloud Migration Assistant from the Jira server.

  5. Access the following URL: 

    ${Jira_URL}/secure/admin/jira/views/SiteDarkFeatures!default.jspa
  6. Input the following DarkFeature:

    com.atlassian.jira.migration.skip.app.outdated.check 
    com.atlassian.jira.migration.export.all.filters
  7. Click Add (no Jira restart is necessary).

  8. Download JCMA 1.9.17 from the Marketplace

  9. Navigate to Settings> Manage apps.

  10. Select the Upload app.

  11. Locate and upload the file to install this specific version.

  12. Go to Settings > System.

  13. In the left panel, locate the Import and Export category, and choose Migrate to cloud

  14. Create a new migration Plan to migrate the dummy project which we created in Step 3

  15. Initiate migration process for transferring filters associated with particular users

  16. 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.

Last modified on Mar 22, 2024

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.