Jira transition recording (in database?)

Question

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 Answer

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.