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 STATUS
| Code Block | ||
|---|---|---|
| ||
select `KEY` as `Issue`, wss.NAME as `Status` from ISSUE i join WORKFLOWSTATUSSTATUS wss on i.STATUSID=wss.ID where i.JQL= 'project = PROJECTNAME' |
| Info |
|---|
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. |
...