Empty Jira workflow status table

[Babs Adewole]

I'm trying to do some analysis on the statuses on a Jira Datacenter instance from the database.  I needed to get the statuses being used on a workflow and those not being used and that would require using the jiraworkflowstatuses table on the database. But the table is empty. Any ideas why this might be happening. Are there other table where the status - workflow mappings may be stored?

[Nic Brough -Adaptavist-]

I strongly recommend that you don't look at the database at all,  For this particular query, you'd need to join 8 tables and do some parsing of one of the fields to enable the join.

Just don't look at a Jira database, it's the worst possible way to report on Jira data.

You can easily see unused status from the UI - go to Admin -> Issues -> Statuses and look down the list for any with a delete option on them.

[Babs Adewole]

Thank you so much for your help. But the issue here is this table is not empty on the other databases I have access to. I can't seem to understand why it's empty in this case

[Nic Brough -Adaptavist-]

This is why you should not be looking at the database. The problem is not the table being empty, the problem is that you are looking at the wrong thing.

[Kian Stack Mumo Systems]

I would check out the Atlassian documentation on issue status and workflow steps. https://developer.atlassian.com/server/jira/platform/database-issue-status-and-workflow/