This queries convert issue Type ID into text and icon format
| Info |
|---|
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. |
| Code Block | ||
|---|---|---|
| ||
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…
| Tip |
|---|
Also you can add issue type icon for better visualisation. Use for this function “IMG” (image). |
| Code Block | ||
|---|---|---|
| ||
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' |
