Content Comparison

...

Here you will find the list of the most used SQL queries!

Please pay attention to the

Note
WARNINGS

and

Info
INFO

...

Table of Contents

...

✅ select ISSUES from…

This query allows you to create a table that includes issues according to your JQL query

...

DESCRIPTION

QUERY

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 sprints

Code Block

language	sql

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

This query allows you to convert issue status ID into text format

...