Fields missing from JQL auto complete due to missing customfieldsearcherkey
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
問題
Fields do not appear in auto complete when using advanced search in Issue Navigator. This has been seen after upgrades.
診断
Check the custom field in the database to see if the "customfieldsearcherkey" is populated.
Use the following to obtain list of custom fields:
SELECT id,cfname,customfieldsearcherkey FROM customfield;- Find custom field in the list
- If the customfieldsearcherkey is empty then you may be affected by this issue.
If customfieldsearcherkey is empty, proceed to Resolution and attempt to obtain the correct customfieldsearcherkey for this customfield
原因
It is unknown how the data got into this state.
ソリューション
Step 1: Obtain Correct Value
First, obtain the correct "customfieldsearcherkey" for the field and add it to the database.
If you find that the customfieldsearcherkey is empty in all cases then you may be affected by a different problem. Contact Atlassian Support for assistance. Provide the following when contacting support:
- Link to this article
- Results of the diagnosis database query
- Zip をサポート
Methods to obtain correct value:
1) Look at another instance of JIRA with this same custom field
- This may be a new instance you set up to get the correct value, or it could be an existing instance of JIRA that is the same version and has the same custom field.
2) Look in an XML backup that was created before this problem occurred
- Search for "<CustomField id=######" where ###### is the ID of the field identified in the Diagnosis section
Step 2: Add Value to Database
データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。
1) Make a backup of your data
2) Shutdown JIRA
3) Add value using the following SQL, or similar SQL:
UPDATE customfield
SET customfieldsearcherkey = 'XXXXXXXXXXXXX'
WHERE id = ######;----NOTES----
- Replace "XXXXXXXXXXXXX" with the correct customfieldsearcherkey
- Replace "######" with the ID of the field identified in the diagnosis step
4) Start JIRA
5) Reindex JIRA
例
The following is an example of how the Epic custom fields appear. These fields were create by JIRA Software (JIRA Agile).
- These examples show the correct customfieldsearcherkey for these particular fields.