/
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
Read with this
To get started
To get started
Read with this
ICONS
Read with this
LINK ISSUE
Read with this
STATUS ID
Read with this
Format DATE
Read with this