Where the Jira Workflow Transition Conditions are saved in the database?

[Ranganathan]

Hi,

I need to do a immediate maintenance on our workflows. I need a SQL query to retrieve all the Transition Conditions for a given workflow, from the database.

Thanks In Advance!!!

[Alexey Matveev · Accepted solution]

You can get info about a workflow by this query

SELECT id, workflowname, creatorname, descriptor, islocked
FROM jiraworkflows;

but all info is saved in the descriptor field in xml format. You would need to parse the xml file.

[Matt Doar]

Or use ScriptRunner to access the workflow Java object and go from there

[Ranganathan]

Think will have to manually extract from the XML

[Christian Czaia [Decadis AG]]

I guess you should have a look at the jiraworkflows table in the DB.

There has been another question like this here: https://community.atlassian.com/t5/Jira-Core-questions/Which-table-in-database-saves-the-transitions-which-assign-an/qaq-p/391447

Cheers

Christian