Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

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

Abhishek Ravi
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

Answer
Watch
Like Be the first to like this
384 views

1 answer

0 votes
Nic Brough -Adaptavist-
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
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.

View More Comments
Abhishek Ravi
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

Like
Nic Brough -Adaptavist-
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
July 6, 2017

Please see the answer I gave already.

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

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events