Looking for failed test runs with a solved defects, to do a retest
I am looking for all test cases in the TestLab which have solved defects and don't have the run status 'passed'. To do this, I used the dashboard and build the following report:
SELECT BG_BUG_ID, BG_STATUS, BG_PRIORITY, BG_RESPONSIBLE, LINK.LN_LINK_ID, LINK.LN_BUG_ID, LINK.LN_ENTITY_TYPE, LINK.LN_ENTITY_ID, LN_TESTCYCL_ID, TC_CYCLE_ID, TC_TEST_ORDER, TC_STATUS, TS_NAME, TS_STATUS, TS_EXEC_STATUS from (BUG LEFT JOIN LINK ON BG_BUG_ID = LN_BUG_ID ) LEFT JOIN V_LINK_TESTCYCL on LINK.LN_BUG_ID = V_LINK_TESTCYCL.LN_BUG_ID LEFT JOIN CYCLE ON LINK.LN_ENTITY_ID = CY_CYCLE_ID LEFT JOIN TESTCYCL on V_LINK_TESTCYCL.LN_TESTCYCL_ID = TC_TESTCYCL_ID left join test on tc_test_id = ts_test_id Where BG_STATUS IN ('100 - closed') and BUG.BG_RESPONSIBLE = 'myName' /*Defect.Assigned to*/ and TS_EXEC_STATUS IN ('Passed', 'No Run') ORDER BY BG_BUG_ID
But it does not work. Can anyone help?
Maybe I'm misunderstanding, but is the difference here that the requirement is not passed:
...don't have the run status 'passed'
and the query looks for is passed
TS_EXEC_STATUS IN ('Passed', 'No Run')
If you change that line to omit the 'Passed' string, do you get the desired results?
TS_EXEC_STATUS IN ('No Run')