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