Query to identify the name of the statuses associated with the status id's.
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
In few scenarios, the Jira admins / Board admins may configure board filters based on the status IDs. In this case, it's not easy to track the name of the issue statuses for instances with a huge number of issue statuses defined in the workflow. The query mentioned on this page will be helpful to find the status names associated with the issue IDs.
Solution
Run the below SQL query in your Jira database to fetch the status names.
1
select id,pname from issuestatus where id in ('status id 1', 'status id 2')Another way to find the status ID associated with each status is to hover the mouse over the Edit option available on the Issues >> Status page of the Jira application.
The status ID will be displayed at the bottom left corner of the page. Please see the attached screenshot for more details.
Was this helpful?