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.
Manage Confluence like never before! This new learning path teaches you how to manage content, users, and permissions while optimizing user experience. Built for admins at all levels who want to confidently lead and unlock more innovative collaboration.
Learn more
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.