[Database] Link between Table executions and node_hierarchy

LATEST Official version.
Questions and discussions - NO ISSUES
FOR ISSUES => http://mantis.testlink.org

Moderators: Amaradana, TurboPT, TL Developers

[Database] Link between Table executions and node_hierarchy

Postby mfranke » Tue Jun 02, 2015 11:17 am


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,
TestLink user
Posts: 6
Joined: Sun May 31, 2015 5:10 pm

Re: [Database] Link between Table executions and node_hierar

Postby fman » Tue Jun 02, 2015 1:55 pm

Member of TestLink Community
Posts: 3073
Joined: Tue Nov 15, 2005 7:19 am

Return to TestLink 1.9

Who is online

Users browsing this forum: No registered users and 3 guests