This queries convert issue Type ID into text and icon format 

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) as `Type`, LINKISSUE(i.`KEY`)  as `Issue`
from ISSUE i
join ISSUETYPE it on it.ID=i.TYPEID
where JQL='project=PROJECTNAME'