/
Function ASLINK

Function ASLINK

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