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

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 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.

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

Simple SQL

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

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

Support

Function ASICON

Examples