Retrieving workflow details from a database
Other major information that people normally look for in the database is about workflows. What is the current status of an issue? How does one find out which workflow an issue is associated with? Where is the workflow XML stored in the database? In this recipe, we will take a quick tour of the tables related to workflows.
JIRA workflows, as we have seen in the previous chapters, have statuses, steps, and transitions. There is always a one-to-one mapping between status and step and they are always kept in sync. Then, there are transitions which will move the issue from one step to another and, hence, from one status to another.
The workflows themselves are stored as XML files in the jiraworkflows table. JIRA processes these XMLs using the OSWorkflow APIs to retrieve the necessary information for each transition, step, and so on. Any draft workflows are stored in the jiradraftworkflows table.
The jiraissue table holds the ID of its current status and...
