How to Identify Issues that belongs to any Sprint in JIRA
プラットフォームについて: サーバーと Data Center のみ。この記事は、サーバーおよび Data Center プラットフォームのアトラシアン製品にのみ適用されます。
目的
The purpose of this article is to show how to identify issues with Sprint and those that does not belong to any Sprint. This can be done via JQL and SQL.
ソリューション
All the issues that have been put into some sprint:
JQL:
Sprint is not EMPTY
SQL:
select ji.id, concat(P.pkey,concat('-',ji.issuenum)) from jiraissue ji join project P on P.id = ji.project join customfieldvalue cv on ji.id=cv.issue join customfield cf on cf.id=cv.customfield where cf.cfname='Sprint'
All the issues that have not been put into any sprint:
JQL:
Sprint is EMPTY
SQL:
select I.id,concat(P.pkey,concat('-',I.issuenum)) from jiraissue I join project P on P.id = I.project where I.id not in (select ji.id from jiraissue ji join customfieldvalue cv on ji.id=cv.issue join customfield cf on cf.id=cv.customfield where cf.cfname='Sprint')
最終更新日 2022 年 11 月 7 日
Powered by Confluence and Scroll Viewport.