What Database table stores JMWE plugin "Transitions" data

[Qualcomm Support]

I would like to access the table/location where JMWE plugin stores the "Transitions tab" data for every issue?

Can someone please help?

[Nic Brough -Adaptavist-]

Hi,

App (plugin) data is stored mostly in AO tables, as "Active objects" is where apps store stuff that is not storable on the issue, project, field, workflow, etc.

The format of the AO table names is standardised, they are always AO_<app id>_<whatever the app wants to call this table>

As an example, the only one I can ever remember is AO_4B00E6_SCRIPT_RUN_RESULT - the 4B00E6 uniquely identifies Scriptrunner.  The current list of (well known) AO tables is at https://confluence.atlassian.com/jirakb/list-of-jira-server-ao-table-names-and-vendors-973498988.html 

However, two things:

• You should not be looking in an Atlassian database.  They are really not designed for reporting, and unless you've actually looked at the code behind the bit you are looking for, there is a very good chance you will not understand the data in the database.
• A lot of apps provide on-the-fly data.  There might not be anything in the database for what you are looking for.  I do not know how JWME has been coded, but if it were me, the "transitions tab" would be pulled from the issue history via the API, not duplicated into the database.

What is the problem you are trying to solve here?  Is it really just "my people want to see a list of transitions (with date and time)"?  Why are they asking for that?

[David Fischer]

Hi @Qualcomm Support 

JMWE doesn't store any transition data, it just reads it from the Jira database. The way it reads it is actually fairly complicated and proprietary, because Jira stores this information in a very convoluted way. 

But I can point you to the base information: it's partially in the OS workflow tables (that start with OS_ if I remember properly)