Function ASLINK
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:
Type | Notes |
|---|---|
String | Label to be shown as a clickable link in a navigator. |
String | URL. 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 SQLSELECT
ASISSUEKEY(I.ID) ISSUE_KEY,
I.SUMMARY
FROM ISSUES I
LIMIT 4 | SQL with ASLINK functionSELECT
AUX.ASLINK(AUX.ASISSUEKEY(I.ID),'/browse/' || AUX.ASISSUEKEY(i.ID)) ISSUE_KEY,
I.SUMMARY
FROM ISSUES I
LIMIT 4 |
|---|---|
 | |