nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

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!!!

Accepted answers

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.

All comments

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

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_tzgiej

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

Think will have to manually extract from the XML

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira