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…

Vision SQL for Jira

STATUS ID

Analytics

Related content