\nYou want to trace Test Cases to Test Runs. Specifically, you need to identify Test Cases that are not included in Test Runs at any given time.
\n
Solution<\/H2>
\nAs with the last several posts, we find that Lucene, while fine for many querying needs, doesn’t deliver information like this… at least not in a way the doesn’t tax the system too much. Here’s some Wiki page mark-up you can use to find your Test Cases that are not part of any Test Run.
\n1 Test Cases Not Included in Test Runs<\/p>\n1 Query
\n#set($myQuery = “SELECT test.C_PK FROM WORKITEM test, PROJECT proj WHERE =>
\ntest.FK_URI_PROJECT = proj.C_URI AND proj.C_ID = ‘${page.getProject()}’ AND =>
\ntest.C_TYPE = ‘testcase’ AND NOT EXISTS (SELECT record.* FROM =>
\nSTRUCT_TESTRUN_RECORDS record WHERE record.FK_URI_TESTCASE = test.C_URI)”)
\n* $myQuery<\/p>\n
1.1 TestCases
\n{workitems:sqlQuery=$myQuery}
\n<\/PRE>
\n
=> indicates continuation on the same line.<\/P><\/p>\n
<\/p>\n
1 Query
\n#set($myQuery = “SELECT test.C_PK FROM WORKITEM test, PROJECT proj WHERE =>
\ntest.FK_URI_PROJECT = proj.C_URI AND proj.C_ID = ‘${page.getProject()}’ AND =>
\ntest.C_TYPE = ‘testcase’ AND NOT EXISTS (SELECT record.* FROM =>
\nSTRUCT_TESTRUN_RECORDS record WHERE record.FK_URI_TESTCASE = test.C_URI)”)
\n* $myQuery<\/p>\n
1.1 TestCases
\n{workitems:sqlQuery=$myQuery}
\n<\/PRE>
\n
=> indicates continuation on the same line.<\/P><\/p>\n
<\/p>\n
![\"Banner:](\"http:\/\/community.plm.automation.siemens.com\/legacyfs\/online\/siemensplm_blogs\/2014\/06\/polarion-silver-gold-support.jpg\")
<\/A><\/P><\/p>\n","protected":false},"excerpt":{"rendered":"