Versions Compared

Old Version 3

changes.mady.by.user Mariia Romanova

Saved on

compared with

New Version 4

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

Note

Please pay attention that SQL do not allowed 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)

Info

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

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 projectsProjects, usersUsers, Sprints ,etc.

✅ format COMMENTS as ordinary text

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

DESCRIPTION

QUERY

Select Issues and 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'

👥 Sprint team members

Name

Role

...