Page Comparison

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

Note
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…

Info
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.

Select all Issues from a particular project
Code Block
language sql
select * from ISSUE i where JQL='project=PROJECTNAME'

Select all Issues of a current user

Code Block

language	sql

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

Select all Issues from an open sprint

Code Block

language	sql

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

Versions Compared