TestManager Database Schema
I am working on creating reports with Crystal Reports for data within the TestManager Database. I am now trying to make a report that lists the number of test cases for each requirement within ReqPro (also known as Test Input within TestManager). The problem is, I do not know how test inputs map to Test Cases within the TestManager database. Does anyone know how this works? Any help here would be great.
[ 11-21-2005, 08:53 AM: Message edited by: Kris_PerfTester ]
Re: TestManager Database Schema
My local guru tells me that in the TestManager database, there's a "Join Table" called CASE_INPUTS as per the following:
SELECT TestCase.Name, Case_Inputs.TestInputName
FROM TMS.Case_Inputs Case_Inputs, TMS.TestCase TestCase
WHERE Case_Inputs.UID = TestCase.UID
Hope that helps.