[Database] Link between Table executions and node_hierarchy
Posted: Tue Jun 02, 2015 11:17 am
Hello,
as some excel-reports got removed in the new Testlink 1.9 I am trying to build the Query Metrics report by myself.
The only thing I can't figure out is how to get the corresponding testcase-Name to any execution.
The table "executions" holds almost every information I need. Where is the link between "executions" and "node-hierarchy" to get the testcase-name?
I think the link is given by the column "executions.tcversion_id", but I don't know where to link the "tcversions.tc_external_id".
Any help is kindly appreciated!
Thank you,
mfranke
as some excel-reports got removed in the new Testlink 1.9 I am trying to build the Query Metrics report by myself.
The only thing I can't figure out is how to get the corresponding testcase-Name to any execution.
The table "executions" holds almost every information I need. Where is the link between "executions" and "node-hierarchy" to get the testcase-name?
I think the link is given by the column "executions.tcversion_id", but I don't know where to link the "tcversions.tc_external_id".
Any help is kindly appreciated!
Thank you,
mfranke