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 Next »

This query helps to convert STATUSID of an issue into a text format

As you know, a lot of tables in Jira contain columns with fields ID in number format. But its possible to convert all these IDs into text format:

STATUSID is converted into a text by connecting our tables ISSUE and WORKFLOWSTATUS 

select `KEY` as `Issue`, ws.NAME as `Status`
from ISSUE i 
join WORKFLOWSTATUS ws on i.STATUSID=ws.ID
where i.JQL= 'project = PROJECTNAME'

Before…

After…

  • No labels