Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

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 ASISSUEKEY(I.ID) ISSUE_KEY, I.SUMMARY 
FROM ISSUES I 
LIMIT 4

  • No labels