issue status relate workflow

artafon

Hi, I trying to understand which projects using statuses from database. I I thought it's real ability to know from workflow_id of table jiraissue, but i was wrong. Could you help me please? 

Nic Brough -Adaptavist-

Two things:

1.  Why?  The database is not intended to be used directly, and there is almost certainly a much better way of doing whatever it is you are trying to achieve
2. If you insist on doing it the hard way, you'll need to read the project config tables for the workflow scheme in use, compare that with the issue type scheme to work out which workflows are actually used, then parse each workflow xml in turn to get a list of all the status ids, then read the status table to work out the labels for them.