Versions Compared

Old Version 2

changes.mady.by.user Piotr Bojko

Saved on

compared with

New Version 3

changes.mady.by.user Piotr Bojko

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Note

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


Code Block
languagesql
titleSimple SQL
SELECT I.SUMMARY, P.NAME, P.ICONURL 
FROM ISSUES I 
JOIN PRIORITIES P ON I.PRIORITY = P.ID 
LIMIT 4



Code Block
languagesql
titleSQL with ASICON function
SELECT I.SUMMARY, ASICON(P.NAME, P.ICONURL) 
FROM ISSUES I 
JOIN PRIORITIES P ON I.PRIORITY = P.ID 
LIMIT 4


Image Modified

Image Modified