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 3 Next »

These queries allow to display icons of issue types, statuses and piorities

For this you need to use function named IMG()

The formula construction is: IMG(TableName.ICONURL, width,height)

For example: IMG(it.ICONURL,16,16) where:

“it” - alias for table ISSUETYPE

16,16 - width 16 px, height 16 px.

EXAMPLES

  • Add Issue type icon

select IMG(it.ICONURL,16,16) as `Type`, LINKISSUE(i.`KEY`)  as `Issue`
from ISSUE i
join ISSUETYPE it on it.ID=i.TYPEID
where JQL='project=PROJECTNAME'

  • Add description to Issue type icon

In this case we gonna combine two functions IMG and CONCAT (more info about last one here..)

select IMG(it.ICONURL,16,16,CONCAT(it.NAME, ': ', it.DESCRIPTION)) as `Type`,
LINKISSUE(i.`KEY`)  as `Issue`
from ISSUE i
join ISSUETYPE it on it.ID=i.TYPEID
where JQL='project=PROJECTNAME'

  • Add Priority icon 

select LINKISSUE(i.`KEY`)  as `Issue`, 
IMG(ip.ICONURL,16,16 ) as `Priority`
from ISSUE i
join ISSUEPRIORITY ip on ip.ID=i.PRIORITYID
where JQL='project=PROJECTNAME ORDER BY updated DESC'

select LINKISSUE(i.`KEY`)  as `Issue`, 
LOZENGESTATUS(sc.COLOR, s.NAME, true) as `Status`
from ISSUE i
join WORKFLOWSTATUS s on s.ID = i.STATUSID
join WORKFLOWSTATUSCATEGORY sc on sc.ID = s.CATEGORYID
where JQL='project=PROJECTNAME ORDER BY updated ASC'

  • No labels