Jira transition recording (in database?)

[bschmi]

Hi,

I am wondering if Jira records the specific transition (id) in database so I could access it?

For example I have a status / workflow step "On Hold" (7) which has two possible transitions a.) Resume Work (740) b.) Back to Open (790) - both end in status "Open"

where I'd like to count (preferrable via JQL query) how on many issues the transistion "Resume Work" was issued.

From what I can see something like 

status CHANGED FROM "On Hold" TO "Open"

would not answer which transition was used as it relies only on source and target status.

Is there any chance to get information about transitions (id would suffice) of Jira - at all?

Thanks a lot!

Regards,
Birgit

[Nic Brough -Adaptavist- · Accepted solution]

No, the transition id is not stored.  You'll need to think about how to capture it in code, or rely on the status change records.

[Jimmy Van (GLiNTECH)]

Hi Birgit,

Try Jira Misc Custom Fields (https://marketplace.atlassian.com/apps/27136/jira-misc-custom-fields?hosting=server&tab=overview) and then add a Transition Count field to see the number of times a particular transition was executed.