Page Comparison

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

...

...

✅ select ISSUES from…

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

...

select *
from ISSUE i
where JQL='project=PROJECTNAME'

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

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

...

✅ format COMMENTS as ordinary text

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

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'

✅ convert UserID into a text format

select LINKISSUE(i.`KEY`) as `ISSUE`, x.DISPLAYNAME as `Assignee`, y.DISPLAYNAME as `Reporter`
from ISSUE i
join USER x on i.ASSIGNEEID=x.ACCOUNTID
join USER y on i.REPORTERID=y.ACCOUNTID
where i.JQL='project=PROJECTNAME'

...