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
TAGS
atlassian, confluence administration, confluence admin training, confluence learning path, manage users and permissions, confluence certification, atlassian learning, cloud admin tools, streamline collaboration, confluence admin best practices

🚨New Confluence Admin Course Alert!

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
AUG Leaders

Atlassian Community Events