JQL Query Return The Issue History for a Given Issue

[Chris Mazzochi]

I am trying something like this to get the history of a given issue: 

https://upvate.atlassian.net/rest/api/2/search?jql=project="UC-3142" and issuehistory()

Error was expecting an operator.  What would the correct query look like?

Thanks,

Chris Mazzochi

[Kian Stack Mumo Systems · Accepted solution]

Hey there, 

Try this instead. https://upvate.atlassian.net/rest/api/2/issue/UC-3142?expand=changelog. 

Documentation for rest API's can be found here. 

https://developer.atlassian.com/cloud/jira/platform/rest/#api-api-2-issue-issueIdOrKey-get

[Chris Mazzochi]

Beautiful.  
Thank you kindly. 
CM

[Chris Mazzochi]

What about this question Kian?

https://community.atlassian.com/t5/Jira-Core-questions/JQL-Query-Number-of-Change-Log-Issues-Whos-Count-Equaled/qaq-p/694280

[Chris Mazzochi]

Kian what about getting the change log for all issues within a project?

The following query doesn't return the change log...

https://upvate.atlassian.net/rest/api/2/project/UC?expand=changelog

[Kian Stack Mumo Systems]

Is this still from Kipfolio? There isn't an end point for just listing changes made to tickets within a project, but you can search for tickets within a project and expand the changelog still. 

https://upvate.atlassian.net/rest/api/2/search?jql=project%3DUC&maxResults=100&expand=changelog

This will give you up to 100 tickets within project UC and expand the changelog for each issue.

[Safaa OUM]

@Kian Stack Mumo Systems 

It works with : 

URLticket = URLJIra & "rest/api/latest/issue/" & projectName & "?xpand=changelog&fields="""

But not with  :

URLticket = URLJIra & "rest/api/2/search?jql=project=" & NumProjet & "&maxResults=100&expand=changelog"

Any thoughts ? how can I make it work using "jql" ?

[jophc]

Hi @Kian Stack Mumo Systems 

The first link you provided on Dec 22, 2017 is no longer available.

Do you perhaps have another link for this of JQL query to return the issue history?

[Kian Stack Mumo Systems]

For the JQL? Or for a rest end point to return issue history?

Thanks,

Kian

[jophc]

Thanks for the quick response, Kian.

Since I'm new to JIRA and not a person with IT background, I'm not sure how to answer your question.
However, what I would like to see, for reporting purposes, would be a table in where I could find for each row the history changes. So, for the same issue key, we would have several rows, each row containing data for the columns "Field changed", "Original Value", "New Value" and "Change Date".

Is this somehow possible?

[Navarambh Software - Gmail]

Hi,

This is possible with our app: AIO Reports and Timesheets for Jira

https://marketplace.atlassian.com/apps/1212942/aio-reports-and-timesheets-for-jira?hosting=cloud&tab=overview

Documentation link:

https://aioreports.atlassian.net/wiki/spaces/ART/overview

 A sample screenshot is included below. 

For any questions or issues, please email us at support@aioreports.com

Regards

AIO Support