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: 239, Answers: 31)
Asked on February 6, 2017 5:19 pm
23 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: 300)
Answered on February 6, 2017 5:20 pm
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top