ALM 11 - PL/SQL query for export of test lab to Exel
Hello experts. Thanks in advance for your help.
i am trying to create a SQL query for an Excel report The report should create a dump of everything in the Test Lab area. So far, I have come up with the query shown below. It appears to only be pulling a subset of the data. Do you have any idea as to what I am doing wrong? Else, can you please provide a better query? Any solution must be a SQL query only, it cannot be OTA, etc.
CF1.CF_ITEM_NAME as "1st_Level_Folder"
,CF2.CF_ITEM_NAME as "2nd_Level_Folder"
,CF3.CF_ITEM_NAME as "3rd_Level_Folder"
,CF4.CF_ITEM_NAME as "4th_Level_Folder"
,CYCLE.CY_CYCLE as "Test_Set"
,TEST.TS_NAME as "Test_Case_Name"
,CYCLE.CY_COMMENT as "Description"
WHERE CF1.CF_FATHER_ID = '0' --Top Level Folder
AND CF2.CF_ITEM_NAME !='DELETE'