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.

  1. Use the following to obtain list of custom fields:

    SELECT id,cfname,customfieldsearcherkey FROM customfield;
  2. Find custom field in the list
  3. 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:

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 = ######;


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

Expand for XML backup example...
    <CustomField id="10002" customfieldtypekey="com.pyxis.greenhopper.jira:gh-epic-link" customfieldsearcherkey="com.pyxis.greenhopper.jira:gh-epic-link-searcher" name="Epic Link" description="Choose an epic to assign this issue to."/>
    <CustomField id="10003" customfieldtypekey="com.pyxis.greenhopper.jira:gh-epic-status" customfieldsearcherkey="com.pyxis.greenhopper.jira:gh-epic-status-searcher" name="Epic Status" description="Epic Status field for JIRA Software use only."/>
    <CustomField id="10004" customfieldtypekey="com.pyxis.greenhopper.jira:gh-epic-label" customfieldsearcherkey="com.pyxis.greenhopper.jira:gh-epic-label-searcher" name="Epic Name" description="Provide a short name to identify this epic."/>
    <CustomField id="10005" customfieldtypekey="com.pyxis.greenhopper.jira:gh-epic-color" customfieldsearcherkey="com.pyxis.greenhopper.jira:gh-epic-color-searcher" name="Epic Color" description="Epic Color field for JIRA Software use only."/>
Expand for database example...
select * from customfield where customfieldtypekey like '%epic%';

10003com.pyxis.greenhopper.jira:gh-epic-statuscom.pyxis.greenhopper.jira:gh-epic-status-searcherエピック ステータスEpic Status field for JIRA Software use only.

10004com.pyxis.greenhopper.jira:gh-epic-labelcom.pyxis.greenhopper.jira:gh-epic-label-searcherエピック名Provide a short name to identify this epic.

10005com.pyxis.greenhopper.jira:gh-epic-colorcom.pyxis.greenhopper.jira:gh-epic-color-searcherエピックの色Epic Color field for JIRA Software use only.

10001com.pyxis.greenhopper.jira:gh-epic-linkcom.pyxis.greenhopper.jira:gh-epic-link-searcherEpic Link (エピック リンク)Choose an epic to assign this issue to.

最終更新日 2021 年 8 月 24 日


Powered by Confluence and Scroll Viewport.