Page Comparison

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

...

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

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

...

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

• 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'

...