Select ISSUES

Owned by Mariia Romanova
Last updated: Oct 24, 2022
1 min read

These queries will help you to select issues from different instances according to your JQL query

Please pay attention that SQL does not allow execute all issues from Jira at once. So you need to put Issue ID or JQL query, that selects issues from a particular place (project, user, sprint, board etc) More details…

PROJECTNAME* is a tentative name in our queries. Please note that in your JQLs you need to use real names of your Projects, Users, Sprints ,etc.

 

  1. Select all Issues from a particular project

    select * from ISSUE i where JQL='project=PROJECTNAME'

  2. Select all Issues of a current user

    select * from ISSUE i Where JQL='reporter=currentUser()'

  3. Select all Issues from an open sprint

    select * from ISSUE i where JQL='Sprint in opensprints()'

 

Â