Forums

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

SQL to get history of project role actor

Paresh Gandhi
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.
January 13, 2015

How to find the who has updated the project roles of JIRA with all the history.

 

I have below query which does not provide history

select * from projectroleactor where ROLETYPEPARAMETER = 'groups-name'

1 answer

0 votes
Boris Berenberg
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.
January 13, 2015

Totally wrong answer initially. If you have Audit Log enabled then you can do:

select * from audit_log where object_type = 'PROJECT_ROLE'

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events