How to view the Jira issues linked to a Bamboo Data Center test results via Database queries
プラットフォームについて: Data Center のみ。 - This article only applies to Atlassian apps on the Data Center プラットフォーム。
この KB は Data Center バージョンの製品用に作成されています。Data Center 固有ではない機能の Data Center KB は、製品のサーバー バージョンでも動作する可能性はありますが、テストは行われていません。 Server* 製品のサポートは 2024 年 2 月 15 日に終了しました。Server 製品を実行している場合は、 アトラシアン Server サポート終了 のお知らせにアクセスして、移行オプションを確認してください。
*Fisheye および Crucible は除く
要約
The purpose of this article is to provide details of the Database tables which stores the Jira issues linked to a test case and provide a SQL query to fetch that.
Currently this information can only be seen via Bamboo GUI ( refer below ) under each test cases for which the Jira issue is created and there is a feature request raised to fetch this information via Rest API, details at BAM-25530 - Make Jira issues linked to test case results be listed as a linked issue on the general build results
環境
The solution has been tested on Bamboo 9.6.0 and Postgres SQL DB, but it is applicable for other supported version as well and the query can be run on other DB types as well.
ソリューション
The below SQL can be used to fetch all the Jira issues created for a main plan and can be modified accordingly based on requirement.
SELECT DISTINCT B.FULL_KEY AS plan_key,
B.TITLE AS plan_name,
TCA.LINKED_JIRA_ISSUE AS jira_issue
FROM BUILD B,
TEST_CLASS TC,
TEST_CASE TCA
WHERE B.BUILD_ID = TC.PLAN_ID
AND TC.TEST_CLASS_ID = TCA.TEST_CLASS_ID
AND B.BUILD_TYPE = 'CHAIN'
AND TCA.LINKED_JIRA_ISSUE IS NOT NULLこの内容はお役に立ちましたか?