Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

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.

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

  • No labels