How to Identify Issues that belongs to any Sprint in JIRA

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

Purpose

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.

Solution

  1. All the issues that have not been put into any sprint:

    1. JQL:

      Sprint is not EMPTY
    2. SQL:

      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'
  2. All the issues that have been put into some sprint:

    1. JQL:

      Sprint is EMPTY
    2. SQL:

      select id from jiraissue where 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')
Last modified on Mar 27, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.