Excerpt
Functions converts issue id to its appropriate key.

Function takes following parameters:

Type	Field
BIGINT	Id of an issue

Examples

Code Block

language	sql
title	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

Code Block

language	sql
title	SQL with ASISSUEKEY function

SELECT AUX.ASISSUEKEY(I.ID) ISSUE_KEY, I.SUMMARY 
FROM ISSUES I 
LIMIT 4

...

Versions Compared