Select - show test case name and execution notes

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

Moderators: Amaradana, TurboPT, TL Developers

Select - show test case name and execution notes

Postby Charon » Mon Oct 08, 2018 7:42 am

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?
Charon
TestLink user
 
Posts: 3
Joined: Thu Oct 04, 2018 6:51 pm

Re: Select - show test case name and execution notes

Postby fman » Mon Oct 08, 2018 8:53 am

Have you searched for schema and found something old? Here , on twitter on Mantis ?
fman
Member of TestLink Community
 
Posts: 3024
Joined: Tue Nov 15, 2005 7:19 am

Re: Select - show test case name and execution notes

Postby Charon » Tue Oct 09, 2018 9:15 am

Yes, I found db schema for v. 19.16.11, but part of tables nodes_hierarchy and executions is different.
Charon
TestLink user
 
Posts: 3
Joined: Thu Oct 04, 2018 6:51 pm

Re: Select - show test case name and execution notes

Postby fman » Wed Oct 10, 2018 3:07 pm

it will be great to understand what are the differences
fman
Member of TestLink Community
 
Posts: 3024
Joined: Tue Nov 15, 2005 7:19 am

Re: Select - show test case name and execution notes

Postby Charon » Wed Oct 10, 2018 6:53 pm

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 ?
Charon
TestLink user
 
Posts: 3
Joined: Thu Oct 04, 2018 6:51 pm


Return to TestLink 1.9



Who is online

Users browsing this forum: No registered users and 6 guests

cron