Forums

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

How I can get list of deployed issues via API?

Deleted user July 18, 2018

Now we get list of jira issues from the build like this http://bamboo.companyname.com/rest/api/latest/result/PROJ.json?buildstate=Successful&expand=results.result.jiraIssues&max-results=10

Is there any possibility to get list of issues from last deployed build?

1 answer

0 votes
Foong
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 24, 2018

There isn't any API to get the last deployed release's issues.

You may want to consider getting it from database:

SELECT dvji.* FROM
DEPLOYMENT_RESULT dr
JOIN DEPLOYMENT_VERSION_JIRA_ISSUE dvji ON dvji.DEPLOYMENT_VERSION_ID=dr.VERSION_ID
WHERE dr.DEPLOYMENT_RESULT_ID=
(SELECT MAX(DEPLOYMENT_RESULT_ID) FROM
DEPLOYMENT_PROJECT dp
JOIN DEPLOYMENT_ENVIRONMENT de ON de.PACKAGE_DEFINITION_ID=dp.DEPLOYMENT_PROJECT_ID
JOIN DEPLOYMENT_RESULT dr ON dr.ENVIRONMENT_ID=de.ENVIRONMENT_ID
WHERE dr.DEPLOYMENT_STATE='Successful'
AND dp.NAME='<projectName>'
AND de.NAME='<environmentName>');

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events