时间戳

首页 > 解决方案 > 用于从 ALM 获取链接到测试集、测试用例和测试步骤的缺陷的 SQL 查询

alm - 用于从 ALM 获取链接到测试集、测试用例和测试步骤的缺陷的 SQL 查询

问题描述

我正在使用以下查询，但它没有提取与测试用例的测试步骤相关联的缺陷。
因此，与测试步骤相关的所有缺陷都不会出现。

SELECT Distinct BUG.BG_BUG_ID as "Defect ID", BUG.BG_DETECTED_BY as "Detected By", BUG.BG_SUMMARY as "Defect Name", BUG.BG_USER_03 as "Application", BUG.BG_USER_01 as "Category", LINK.LN_ENTITY_TYPE as "Type", TEST.TS_TEST_ID as "Test ID", TEST.TS_NAME as "Test Name", TEST.TS_USER_03 as "Test Category"
FROM LINK, BUG, TEST,STEP Where LINK.LN_BUG_ID = BUG.BG_BUG_ID AND LINK.LN_ENTITY_ID = TS_TEST_ID --AND BUG.BG_STATUS in ('Closed', 'Canceled', 'Duplicate') AND BUG.BG_DETECTED_IN_RCYC in (Select RELEASE_CYCLES.RCYC_ID from RELEASE_CYCLES where RELEASE_CYCLES.RCYC_NAME IN ('UAT - 3.1 MVA'))

Order by BUG.BG_BUG_ID

标签： alm

解决方案

推荐阅读