TestCases not associated to any testplan

[Greco]

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.

[GunnarD]

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"

[fman]

>> 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?