Highlighted
Valued Contributor.
Valued Contributor.
510 views

ALM - SQL query to fetch the execution report

ALM - SQL query to fetch the execution report

Please let me know the SQL query to fetch the execution report in ALM.

The Query should display the run details(whatever is stored in history), no. of times the test case executed, each exec status, exe date and time etc...


In Oracle, we are using sys_connect_by_path -> this keyword is not identified in SQL database

0 Likes
1 Reply
Highlighted
Valued Contributor.
Valued Contributor.

Hi Hari,

Please send me the SQL version of the below query for SQL database. The below oracle query was shared by you which is working fine in oracle database

 

select unique path as "Test Set Folder Path", A.cf_item_name as "Test Set Folder Name", cy_cycle as "Test Set Name",ts_exec_status as "Test Execution status", tc_actual_tester as "Tester Name",tc_exec_date as "Execution Date",tc_exec_time as "Exec time",rn_duration as "Duration",ts_user_01 as "Test Instance Approval Status",ts_name as "Test Script Name"

FROM CYCLE
JOIN TESTCYCL ON TESTCYCL.TC_CYCLE_ID = CYCLE.CY_CYCLE_ID
JOIN TEST ON TEST.TS_TEST_ID = TESTCYCL.TC_TEST_ID
JOIN CYCL_FOLD ON CYCL_FOLD.CF_ITEM_ID = CYCLE.CY_FOLDER_ID
LEFT OUTER JOIN RUN ON RN_CYCLE_ID=CY_CYCLE_ID AND RN_TEST_ID=TS_TEST_ID AND RN_TESTCYCL_ID=TC_TESTCYCL_ID
//JOIN STEP ON RN_RUN_ID=ST_RUN_ID
inner join
(
select CF_ITEM_ID,cf_item_name,path from
(
select CF_ITEM_ID, cf_item_name,sys_connect_by_path(CF_ITEM_NAME, '\') path
from  CYCL_FOLD connect by prior CF_ITEM_ID = CF_FATHER_ID
start with CF_FATHER_ID = -1 and CF_ITEM_NAME= 'Root'
) where  path like '\Root\DOM\IT1\Global%'
) A
on cy_folder_id = A.CF_ITEM_ID

 

Thanks,

Nisha.

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.