where I can retrieve transaction dates and times?

[Ruwan Mettananda]

In our JIRA, we have around 100 projects. We need to create a Oracle view to visualize following data.
Our work-flow has following statuses
Open
Fix
Resolved
Test
Validate
Closed
Rejected

For a single project, if issues are Delivery-CR, Fault-Bug, Fault-Specification, Fault-Configuration or Fault-Testing we need to create a view to visualize following data.

• transition date – open to fix
• transition date – fix to resolved
• transition date – resolved to test
• transition date – test to validate

I can't find a table to get transaction dates.

We are using JIRA 6.3.7 and Oracle 11g database

[Nic Brough -Adaptavist- · Accepted solution]

It's in changeitem and changegroup.  Changeitem lists the status as though it's a field, and the changed from and to values.  You need to join it to changegroup which holds the issue that was changed, date/time, and who did it.