Page 1 of 1

Select - show test case name and execution notes

PostPosted: Mon Oct 08, 2018 7:42 am
by Charon
Hello
please where is the db schema for version 1.19.16?

How write select
1) to display test case with test steps
-the TC name is in the table `nodes_hierarchy`
-and a description of the test steps is in the table `tcsteps`

how is the link made?

2) to view notes when executed and want to add test case name
select is:
select executions.id, executions.tester_id, users.first, users.last, executions.execution_ts, executions.tcversion_id, executions.notes
from executions, users
where executions.tester_id = users.id
and executions.id = 2318
and executions.build_id = 27
and executions.status = "f"
and executions.testplan_id = 82557

How is the link to test case name?

Re: Select - show test case name and execution notes

PostPosted: Mon Oct 08, 2018 8:53 am
by fman
Have you searched for schema and found something old? Here , on twitter on Mantis ?

Re: Select - show test case name and execution notes

PostPosted: Tue Oct 09, 2018 9:15 am
by Charon
Yes, I found db schema for v. 19.16.11, but part of tables nodes_hierarchy and executions is different.

Re: Select - show test case name and execution notes

PostPosted: Wed Oct 10, 2018 3:07 pm
by fman
it will be great to understand what are the differences

Re: Select - show test case name and execution notes

PostPosted: Wed Oct 10, 2018 6:53 pm
by Charon
How is the link (relation) between table nodes_hierarchy and a description of the test steps in the table tcsteps?
How is the link (relations) between test case name and table executions ?