Created On:  14 September 2012

Problem:

Is it possible to create a report that will return a list of Manual Test Definitions currently being executed with a status of "Not Executeds"?

Resolution:

The following SQL query will return all Manual Tests with a status of "Not executed":
SELECT TM_TestDefExecutions.TestDefID_fk, TM_TestDefExecutions.TestDefName, TM_TestDefExecutions.TestDefDescription FROM TM_ManualTestResults INNER JOIN TM_TestDefExecutions ON TM_TestDefExecutions.TestDefExecID_pk_fk=TM_ManualTestResults.TestDefExecID_pk_fk INNER JOIN TM_ExecDefinitionRuns ON TM_ExecDefinitionRuns.ExecDefRunID_pk_fk=TM_TestDefExecutions.ExecDefRunID_fk WHERE TM_ManualTestResults.ChangedBy IS NULL AND TM_TestDefExecutions.Status=3
The above report will return the following data:
Test ID, Test Name and Description

Incident #2577073