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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.