Today I got a task to search a test in Test Lab. I can only got the run name "Run_1-8_11-23-03".I have no idea about the test set or anything else.
Is there any method to search on run name?
From the RUN table you can retrieve the TestCycleID (TestInstanceID), the CycleID(TestSetID) and also the TestID(Test of TestPlan ID). So you can get all you want.
Something like this:
SELECT TS_NAME FROM TEST t, RUN rwhere t.TS_TEST_ID = r.RN_TEST_ID and r.RN_RUN_NAME LIKE 'Run_1-8_11-23-03'