Versions Compared

Old Version 4

changes.mady.by.user Mariia Romanova

Saved on

compared with

New Version 5

changes.mady.by.user Mariia Romanova

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

Table of Contents
maxLevel3
minLevel2
indent5px
stylecircle
separatorpipe

...

✅ 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
languagesql
select *
from ISSUE i
where JQL='project=PROJECTNAME'

Select all Issues of a current user

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

Select all Issues from an open sprints

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

✅ convert ISSUE STATUS into a text format

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

...

Info

PROJECTNAME* - please note that in JQLs you need to use real names of your Projects, Users, Sprints ,etc.

✅ format COMMENTS as ordinary text

Query converts data from column COMMENTS from HTML to a text format

DESCRIPTION

QUERY

Select Issues and with comments in ( text format) from a particular project

Code Block
languagesql
select i.`KEY` as `Issue`, FORMATHTML(ic.BODY) as `Comment`
from ISSUE i
join ISSUECOMMENT ic on ic.ISSUEID = i.ID
where i.JQL = 'project = PROJECTNAME'

Info

PROJECTNAME* - please note that in JQLs you need to use real names of your Projects, Users, Sprints ,etc.

👥 Sprint team members

Name

Role

...