[Database] Link between Table executions and node_hierarchy

[mfranke]

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

[fman]

http://forum.testlink.org/viewtopic.php?f=26&t=6949