ALM Analysis Report for a list of tests that haven't been pulled into Test Lab

  • Questions
  • ALM Analysis Report for a list of tests that haven't been pulled into Test Lab
Question ID: 107450
0
0

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.

Marked as spam
Posted by (Questions: 230, Answers: 30)
Asked on February 6, 2017 5:19 pm
21 views
Answers (1)
0
Private answer

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

Marked as spam
Posted by (Questions: 2, Answers: 292)
Answered on February 6, 2017 5:20 pm
EyeOnTesting