Note
This function works only when using in our builtin SQL navigator.

Excerpt
This functions "casts" any URL like value to an object which builtin navigator will show as a link to an image.

Basically with this function - you can show an image or icon in table results.

It requires following parameters:

Type	Notes
String	Label to be shown

as a link

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, AUX.ASICON(P.NAME, P.ICONURL) 
FROM ISSUES I 
JOIN PRIORITIES P ON I.PRIORITY = P.ID 
LIMIT 4

Image Modified

Versions Compared