How to get list of Bamboo builds connected to Jira
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Purpose
This article shows how to get a list of Builds connected to Jira.
Environment
Any version of Bamboo.
Solution
You can use a database SQL select to get this information from Bamboo:
SELECT TITLE,
BUILDKEY
FROM BUILD
WHERE LINKED_JIRA_ISSUE IS NOT NULL
AND LINKED_JIRA_ISSUE != '';
Last modified on Sep 8, 2022
Powered by Confluence and Scroll Viewport.