Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Current »

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'

  • No labels