Migrate from Rich Filters Server/Data Center to Cloud

On this page:

1. Introduction

The Rich Filters for Jira Dashboards app uses two different types of data that need to be migrated:

1. The configuration of the rich filters defined on your Jira instance
2. The configuration of the rich filter gadgets used in dashboards on your Jira instance

2. Migrating rich filters

For the migration of the rich filters, you have two possible options:

• migrate your rich filters automatically using the Jira Cloud Migration Assistant (JCMA); the next documentation section describes this migration path in detail;
• migrate your rich filters manually; this means that you need to recreate manually the rich filters from the Server/Data Center instance on your Cloud instance.

2.a. Migrating rich filters configuration automatically using JCMA

The Jira Cloud Migration Assistant (JCMA) allows you to automate the migration of your rich filters from Jira Server/Data Center to Jira Cloud. More precisely, JCMA migrates your Jira data and orchestrates the migration process for 3rd party apps which have added specific support for JCMA.

I) Before launching the JCMA migration

Step #1 - Make sure you have the appropriate software installed on you Jira instances

On your source Jira Server/Data Center instance, make sure you have installed:

• Rich Filters for Jira Dashboards version 1.27.0 or above
• Jira Cloud Migration Assistant (JCMA) latest version

On your destination Jira Cloud instance, make sure you have installed and licensed the Rich Filters for Jira Dashboards Cloud app.

Step #2 - Assess your apps

The first step in configuring JCMA before launching a migration is "1. ASSESS YOUR APPS" on the Migration Assistant home screen – more information available here. As part of this step, you need to chose which apps you wish to migrate to Cloud.

• You need to mark Rich Filters for Jira Dashboards as Needed in cloud. Note that all the rich filters will be migrated.
• If you also use any rich filters extensions apps, then you must mark all of them as Not needed in cloud.

On Cloud, the functionality provided by Rich Filters::Service Management Dashboards is available as part of the main Rich Filters for Jira Dashboards app. Hence, when migrating the main rich filters app, the data provided by this rich filters extension is also migrated.

Currently, the functionality provided by Rich Filters::Time Tracking Dashboards is not supported on Cloud.

II) After completing the JCMA migration

The following steps need to be completed on the destination Jira Cloud instance, after the JCMA migration is finished.

Step #3 - Check and migrate the saved base Jira filters

Rich filters are based on saved Jira filters. Unfortunately, as of version 1.16.8 (the last version we have tested), JCMA migrates only those Jira filters which are associated with boards that are migrated (see the What gets migrated with the Jira Cloud Migration Assistant documentation page).

If your rich filters are based on saved Jira filters which are not migrated by JCMA, then your rich filters will be migrated but their Jira filters will not be set (because the saved Jira filters don't exist on the destination Jira Cloud instance). As part of the post-migration steps, you will have to manually migrate the relevant Jira filters and set them manually in the rich filters.

SELECT rf.ID as rich_filter_id, rf.NAME as rich_filter_name, 
	   jf.id as jira_filter_id, jf.filtername as jira_filter_name, 
       jf.authorname as jira_filter_owner, jf.reqcontent as jira_filter_jql
FROM AO_24D977_QRFRFE0 rf INNER JOIN searchrequest jf ON rf.JIRA_FILTER_ID=jf.ID 
ORDER BY jira_filter_id, rich_filter_id;

SELECT rf."ID" as rich_filter_id, rf."NAME" as rich_filter_name, 
	   jf.id as jira_filter_id, jf.filtername as jira_filter_name, 
       jf.authorname as jira_filter_owner, jf.reqcontent as jira_filter_jql
FROM "AO_24D977_QRFRFE0" rf INNER JOIN searchrequest jf ON rf."JIRA_FILTER_ID"=jf.id
ORDER BY jira_filter_id, rich_filter_id;

The rich filters migrated on the Cloud instance for which the base Jira filters were not migrated will display their Jira filters as NOT SET. You'll need to go through the list of migrated rich filters and for each rich filter, if its base Jira filter was not already migrated as part of the JCMA migration, to manually create the corresponding Jira filter and set it as base filter in the configuration of the rich filter. We remind you that only administrators can edit rich filters (for more details, see the Rights and Permissions documentation page).

Step #4 - Review and update JQL clauses in the configuration of your rich filters

Update custom field id references in JQL

Moreover, if in any of your JQL clauses were referring to a custom field using its cf[id] form, that reference is not automatically updated either. For example, if on your Jira Server/Data Center you used the JQL query cf[10100] is not empty, then the reference to the custom field id is not translated when migrating on Cloud. The JQL clause is migrated as-is but the id of the migrated custom field 10100 might be different on Cloud. Hence, if you used any such custom field references in your JQL, you will have to manually update them on Cloud.

2.b. Migrating rich filters configuration manually

Alternatively, instead of using JCMA, you also have the option to migrate your rich filters manually – i.e. recreate the same rich filters configurations on your Cloud instance. One advantage that this approach brings is that you can decide to not migrate rich filters which are not used anymore.

The SELECT SQL query provided in the Step #3 above can be useful in order to obtain a flat list of rich filters on your Jira Server/Data Center instance.

3. Migrating rich filter gadgets

Unfortunately, Atlassian does not currently provide support for the automatic migration of 3rd party gadgets from Jira Server/Data Center to Jira Cloud. It is for this reason that at least for now, the migration of your dashboards and rich filter gadgets can be done only manually. You need to recreate the same dashboards as on the Jira Server/Data Center instance, using the rich filters already migrated as described above.

SELECT distinct d.id as dashboard_id, d.pagename as dashboard_name, d.username as dashboard_owner_username, 
       p.userprefvalue as rf_id, rf.NAME as rf_name
FROM portalpage d, portletconfiguration g, gadgetuserpreference p, AO_24D977_QRFRFE0 rf
WHERE d.id = g.portalpage
	AND g.id = p.portletconfiguration
	AND p.userprefkey = 'rf'
	AND p.userprefvalue = rf.ID
ORDER BY dashboard_id;

SELECT distinct d.id as dashboard_id, d.pagename as dashboard_name, d.username as dashboard_owner_username,
       p.userprefvalue as rf_id, rf."NAME" as rf_name
FROM portalpage d, portletconfiguration g, gadgetuserpreference p, "AO_24D977_QRFRFE0" rf
WHERE d.id = g.portalpage
    AND g.id = p.portletconfiguration
    AND p.userprefkey = 'rf'
    AND p.userprefvalue = cast(rf."ID" as varchar)
ORDER BY dashboard_id;