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; } } }

How do i get a list of all transitions in my system?

Andrei [errno]

I can easily get a list of all statuses in my JIRA - what query should I run to get a list of all configured transitions? thanks

Accepted answers

Norman Abramovitz

The transitions are stored in the xml text in the jiraworkflows table in the descriptor field. You will need some xml parser to extract what you want.

All comments

Norman Abramovitz

The transitions are stored in the xml text in the jiraworkflows table in the descriptor field. You will need some xml parser to extract what you want.

Andrei [errno]

- thank you!

Martin Radile

Hi webwesen, could you please tell how you fetch the list of all statuses in Jira?

MB_en15bm

ComponentAccessor.getConstantsManager().getStatusObjects()

Andrei [errno]

in your JIRA DB:

SELECT `pname` FROM `issuestatus`

Raman SaravanaKumar

hi @Norman Abramovitz how to view full XML file in descriptor field in jiraworkflows table.

Welcome!

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

Quick Links

Find more posts tagged with

jira

transition

workflow