The statement below extracts Test data that are into TestSets starting from a Folder in TestLab section linked to a Test Cycle declared into the Release section. The Record Data are:

• Release
• Test Cycle
• TestLab Folder
• TestSet
• Test Name
• Execution Status

Prerequisit is the NodeID of the Starting TestLab Folder.

Suppose that the NodeID is 196. Here it is the query:

SELECT A.REL_NAME AS RELEASE,
              B.RCYC_NAME AS CYCLE,
              C.CF_ITEM_NAME AS FOLDER,
              D.CY_CYCLE AS TESTSET,
              E.TS_NAME AS TEST,
              F.TC_STATUS AS EXEC_STATUS
FROM CYCL_FOLD C
           JOIN (SELECT CY_CYCLE_ID,

                                     CY_CYCLE,

                                     CY_FOLDER_ID,

                                     CY_ASSIGN_RCYC FROM CYCLE) AS D

                       ON D.CY_FOLDER_ID = C.CF_ITEM_ID
           JOIN (SELECT RCYC_ID,

                                     RCYC_NAME,

                                     RCYC_PARENT_ID FROM RELEASE_CYCLES) AS B

                       ON B.RCYC_ID = D.CY_ASSIGN_RCYC
           JOIN (SELECT TC_TESTCYCL_ID,

                                     TC_CYCLE_ID,

                                     TC_TEST_ID,

                                     TC_STATUS FROM TESTCYCL) AS F

                       ON F.TC_CYCLE_ID = D.CY_CYCLE_ID
           JOIN (SELECT TS_TEST_ID,

                                    TS_NAME FROM TEST) AS E

                       ON E.TS_TEST_ID = F.TC_TEST_ID
           JOIN (SELECT REL_NAME,

                                    REL_ID FROM RELEASES) AS A

                       ON A.REL_ID = B.RCYC_PARENT_ID
WHERE C.CF_ITEM_ID = 196