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

[Norman Abramovitz · Accepted solution]

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!

[SaravanaKumar]

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

[Andrei [errno]]

in your JIRA DB:

SELECT `pname` FROM `issuestatus`

[MB]

ComponentAccessor.getConstantsManager().getStatusObjects()

[Martin Radile]

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