Get issues by Workflow transitions and the user who performed the transition

[Abhishek Ravi]

Is it possible to create a Oracle Database View to capture relavant Issue information for a Specific project Along with its specific Workflow Transitions and who performed the specific Workflow transitions

[Nic Brough [Adaptavist]]

No, because the transitions are not logged.

The change of status is logged, but it's going to be an ugly and unweildy query to report on.  Look in changeitem and changegroup for the basic information.

[Abhishek Ravi]

hi Nic, Thanks for the reply, Any idea where activity section of the JIRA issue is stored (in which DB table)

Regards,

Abhishek

[Nic Brough [Adaptavist]]

Please see the answer I gave already.

(If you mean "the activity stream", it's not stored, it's extracted)