How can I get the full path name of a test in QC?
I'm using the excel report generator and I'm trying to build a query, I'm getting most of the information I need, but I don't know the table and field for the full path for a test set.
My tests are stored like this,
root\major version\minor version\platform\regression tests
How can I get a report with the full path of the test set so I can identify the build version?
For whatever it is worth, my query looks like this;
SELECT A.CY_CYCLE, C.TS_NAME, C.TS_EXEC_STATUS, B.TC_ACTUAL_TESTER
FROM CYCLE A, TESTCYCL B, TEST C
WHERE A.CY_CYCLE_ID = B.TC_CYCLE_ID AND B.TC_TEST_ID = C.TS_TEST_ID