Function ASLINK

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.

It requires following parameters:

TypeNotes
StringLabel to be shown as a clickable link in a navigator.
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 
 ASISSUEKEY(I.ID) ISSUE_KEY,
 I.SUMMARY 
FROM ISSUES I 
LIMIT 4
SQL with ASLINK function
SELECT 
 AUX.ASLINK(AUX.ASISSUEKEY(I.ID),'/browse/' || AUX.ASISSUEKEY(i.ID)) ISSUE_KEY,
 I.SUMMARY 
FROM ISSUES I 
LIMIT 4