Issue Summary

JQL filters with non-English custom field names fail to function after migration

Steps to Reproduce

1. Create a brand new Jira Software instance
2. Unlock all custom fields following Unlock a locked Jira Software custom field
3. Delete all custom fields
4. Change admin user language to Chinese (or any non-English language)
5. Create a new project with sample data
6. Observe board has default JQL

   project = KAN ORDER BY 等级 ASC
   

   等级 is the Jira Software generated rank custom field

1. Migrate board using JCMA
2. Observe Jira filter in Cloud

   project = KAN ORDER BY 等级 ASC 
   

   JCMA has migrated the data as is.
   When running the filter, the filter returns an error - Not able to sort using field '等级'.

This is due to JRACLOUD-72294: Ability to allow JQL to use translated fields in Advanced Searching Query

Expected Results

1. JQL sorted by translated custom fields should continue to sort, OR
2. JCMA updates JQL from 'ORDER BY 等级' with 'ORDER BY Rank'

such that the JQL continues to function.

Actual Results

Error is returned - Not able to sort using field '等级'.

Workaround

1. Update all JQL filters prior to migration.
   These may be detected with:

   SELECT *
   FROM searchrequest
   WHERE reqcontent LIKE '%ORDER BY 等级%'
   

   Replace "等级" as necessary

1. Contact Atlassian support after your production migration

Generic Workaround for any translated custom fields referred in JQLs

1. Identify all JQL filters prior to migration in the source.
2. Update the JQLs such that the CFs are in English.
3. Migrate to cloud and verify if the filters work fine.