execution status history
I want to create a HPALM sql query, which gives me the history of the execution status. In fact I want to know, if a testcase has ever been 'passed' since it was executed.
There is a manual way of doing this: If I click on a testcase within the HP ALM application, a window 'Test Instance Details" pops up. On the left side there is a 'History' Link. When I click on that, I can select the Field 'Test: execution status' All these entries are exactly what I am interested in.
I do not know where or how to start building a sql query which gives me the above described result.
Do you have any clue what tables contain the information I am looking for? Or which I have to join.
I assume the following:
TESTCYCL - contains the information you see in the Execution Grid in the Test Lab for a Test Set
CYCLE - contains the information about a Test Set
CYCL_FOLD - contains the information about the Folders of the Test Lab tree
TEST contains the information about the Test Case.
Kindly appreciate all hints.