Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

where I can retrieve transaction dates and times?

Ruwan Mettananda
Contributor
March 10, 2015

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

1 answer

1 accepted

1 vote
Answer accepted
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 10, 2015

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.

Suggest an answer

Log in or Sign up to answer