Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Current »

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 sprints 

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

  • No labels