Field 'development' does not exist or you do not have permission to view it when using the JQL Advanced search
プラットフォームについて: サーバーと Data Center のみ。この記事は、サーバーおよび Data Center プラットフォームのアトラシアン製品にのみ適用されます。
要約
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 | DESCRIPTION | DEFAULTVALUE | FIELDTYPE | PROJECT | ISSUETYPE |
---|---|---|---|---|---|---|---|---|---|
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 を再起動します。