STATUS ID

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 STATUS

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

PROJECTNAME* is a tentative name in our queries. Please note that in your JQLs you need to use real names of your Projects, Users, Sprints ,etc.

Before…

After…