TestLink

Posted: **Wed Feb 06, 2013 2:55 pm**

HI all,

I was wondering how to query the DB to obtain the testcases not associated to any testplan, I assumed that it must be:

Code: Select all

select * from tcversions where id not in (select tcversion_id from testplan_tcversions)

but it doesn`t seem correct. There are no null on testplan_id attribute on testplan_tcversions.

Also, other related problem,

Where is in DB scheme the association between cases and its project, it doesn't seem to be anywhere, neither tc_versions nor nodes hierarchy...

I don't know how you run the queries programatically in the app, but the DB isn't very intuitive.

Thanks in advance.

Posted: **Wed Feb 06, 2013 3:13 pm**

Do u have DB schema? http://www.teamst.org/forum/viewtopic.php?f=26&t=6949

I would guess that the connection is "Test Case" -> "Test suite" -> "Project"

Posted: **Thu Feb 07, 2013 4:32 pm**

>> There are no null on testplan_id attribute on testplan_tcversions.
please explain better what do you mean
what did you get as query result?

TestLink

TestCases not associated to any testplan

TestCases not associated to any testplan

Re: TestCases not associated to any testplan

Re: TestCases not associated to any testplan