Function ASISSUEKEY

Functions converts issue id to its appropriate key.Smart QL does not provide a simple column in table ISSUES with issue key. This is because Jira data model does not contain it either. Issue key is a computed field, because it can be changed over time (ie, due to project key changes or moving issue to another project). 

Function takes following parameters:

TypeField
BIGINT Id of an issue

Examples

Simple SQL
SELECT P.KEY || '-' || CAST(I.NUM as VARCHAR) ISSUE_KEY, I.SUMMARY 
FROM ISSUES I 
JOIN PROJECTS P ON I.PROJECT = P.ID
LIMIT 4
SQL with ASISSUEKEY function
SELECT AUX.ASISSUEKEY(I.ID) ISSUE_KEY, I.SUMMARY 
FROM ISSUES I 
LIMIT 4