We are in need of a data report in excel to display a list of tests that haven’t been pulled from Test Plan over into the Test Lab module.
Answer by jameslcoleman · Feb 06 at 05:20 PM
The query below will get a list of the tests that haven’t been pulled from Test Plan over into the Test Lab module. You may need to tweak it some to fit your needs.
SELECT TS_TEST_ID As 'Test ID', TS_NAME As 'Test Name', TS_RESPONSIBLE As 'Testers Name' FROM TEST LEFT OUTER JOIN TESTCYCL ON (TEST.TS_TEST_ID = TESTCYCL.TC_TEST_ID) WHERE TESTCYCL.TC_TEST_ID IS NULL