jql to get activity on an issue

LTH November 5, 2015

I'm trying to figure out this: given the issue key how can you get all the activity on that specific issue using the API.  So far everything I've tried will only give me the current state of the issue . 

 

2 answers

0 votes
Pablo Beltran
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.
November 7, 2015

You can get the full history of any issue with the SQL for JIRA plugin...

select * 
from issues i inner join issuechanges c on i.id=c.issueid 
where i.key='<your issue key>'
0 votes
GabrielleJ
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.
November 5, 2015

There is nothing in the JQL to get the activity of an issue. You will need to get the issue history either via the JIRA REST API (create your own), an add-on (e.g. JIRACLI) or directly from the JIRA DB.

LTH November 9, 2015

So if you can't use JQL how do you get the activity from the API????

Suggest an answer

Log in or Sign up to answer