Field 'development' does not exist or you do not have permission to view it when using the JQL Advanced search
プラットフォームについて: 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 は除く
要約
The JQL Advanced search is not accepting Development Tools search using the syntax development[pullrequests].open recommended on Advanced searching - development fields reference.
The JQL autocomplete does not work and it returns the error message "Field 'development' does not exist or you do not have permission to view it".
診断
- The Development Tools field might also be affected by the issue described on Fields missing from JQL auto complete due to missing customfieldsearcherkey. In order to check if the searcher key is missed, run the following query:
SELECT * FROM "CUSTOMFIELD" where cfname = 'Development';
- The query should return an output similar to:
ID | CFKEY | CUSTOMFIELDTYPEKEY | CUSTOMFIELDSEARCHERKEY | CFNAME | 説明 | 既定値 | フィールド タイプ | PROJECT | 課題タイプ |
|---|---|---|---|---|---|---|---|---|---|
10000 | NULL | com.atlassian.jira.plugins.jira-development-integration-plugin:devsummary | com.atlassian.jira.plugins.jira-development-integration-plugin:devsummarysearcher | 開発 | Development Summary Field for Jira Software use only. | NULL | NULL | NULL | NULL |
- If the column CUSTOMFIELDSEARCHERKEY is empty, the autocomplete and the search will not work.
原因
It is unknown how the data got into this state.
回避策
JQL supports querying issue properties, and Development tools populate fields in Lucene that looked like issue properties (e.g. issue.property[development].commits).
issue.property[development].reviews > 0
issue.property[development].commits > 0
issue.property[development].openprs > 0
issue.property[development].prs > 0ソリューション
データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。
- Jira を停止します
- Update the column CUSTOMFIELDSEARCHERKEY with the expected value:
update "CUSTOMFIELD" set "CUSTOMFIELDSEARCHERKEY"='com.atlassian.jira.plugins.jira-development-integration-plugin:devsummarysearcher' where cfname = 'Development';
commit;
- Jira を再起動します。