Function ASICON

Owned by Piotr Bojko
Last updated: May 23, 2018

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:

TypeNotes
StringLabel to be shown when no icon is found.
StringURL. 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