Type	Notes
String	Label to be shown when no icon is found.
String	URL. This can be a full url (with http/https prefix) or only a path. When having a path - Jira base url path context is added.

Tip
You can use either full URL like http://link.to.something or a path withouth a base url. In the latter option - link will be enhanced by the base url pointing to JIRA, so you can use the data like ICONURl from PRIORITIES table directly.

Examples

Code Block

language	sql
title	Simple SQL

SELECT I.SUMMARY, P.NAME, P.ICONURL 
FROM ISSUES I 
JOIN PRIORITIES P ON I.PRIORITY = P.ID 
LIMIT 4

Code Block

language	sql
title	SQL with ASICON function

SELECT I.SUMMARY, ASICON(P.NAME, P.ICONURL) 
FROM ISSUES I 
JOIN PRIORITIES P ON I.PRIORITY = P.ID 
LIMIT 4

...

Versions Compared