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
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.
Hi all! Lauren here from the Enterprise Cloud marketing team. I have some exciting Cloud updates from #AtlassianSummit that I wanted to share. We want everyone in your organization to be ab...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG