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'