/
ISSUE TYPE ID
ISSUE TYPE ID
This queries convert issue Type ID into text and icon format
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 LINKISSUE(i.`KEY`) as `Issue`, it.NAME as `Type`
from ISSUE i
join ISSUETYPE it on it.ID=i.TYPEID
where JQL='project=PROJECTNAME'
Before… After…
Also you can add issue type icon for better visualisation. Use for this function “IMG” (image).
select IMG(it.ICONURL,16,16, it.NAME) as `Type`, LINKISSUE(i.`KEY`) as `Issue`
from ISSUE i
join ISSUETYPE it on it.ID=i.TYPEID
where JQL='project=PROJECTNAME'
Related content
USER ID
USER ID
Read with this
To get started
To get started
Read with this
ICONS
ICONS
Read with this
LINK ISSUE
LINK ISSUE
Read with this
STATUS ID
STATUS ID
Read with this
Format DATE
Format DATE
Read with this