Forums

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

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

Abhishek Ravi June 29, 2017

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

1 answer

0 votes
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.
June 29, 2017

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 July 6, 2017

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-
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.
July 6, 2017

Please see the answer I gave already.

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events