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.
Jira Product Discovery Premium is now available! Get more visibility, control, and support to build products at scale.
Learn moreOnline forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.