Highlighted
cjsasaki
New Member.
44 views

Test Run and Test Lab Folder Name (Path) Query

Hi

I have a query on ALM that gets me the Test Run and some other fields including the Folder "cf_item_path" but it only shows like the first folder above, I would like to give me  one more level in the foldera hierarchachy or the path.

What should I add to it?

My query is :

 

Select /*DATOS CASO */
t.ts_test_id as ID_CASO
, t.ts_name as Nombre_caso
, t.ts_creation_date as f_creacion_caso
, cf_item_path "Path"
, rel_name "Release"
, rcyc_name "Nombre Ciclo"
, cf_item_name "Nombre Carpeta"
, cy_cycle "Nombre Tset"
, RUN.RN_RUN_ID "Run id"
, RN_RUN_NAME "Nombre Corrida"
, TESTCYCL.TC_ACTUAL_TESTER "Ejecutor" -- VER
, RUN.RN_STATUS "Estado Corrida"
, RUN.RN_EXECUTION_DATE "Fecha Ejecucion"
, year (RUN.RN_EXECUTION_DATE) "Fecha Ano Ejecucion"
, month (RUN.RN_EXECUTION_DATE)
, RN_EXECUTION_TIME "Hora"
, RN_DURATION "Duracion"
, TESTCYCL.TC_TEST_INSTANCE "Nro Repeticion"
, TS_STATUS "Status del Diseño"
, TS_CREATION_DATE "Fecha de Diseño"
From releases
, RELEASE_CYCLES
, test as T
, CYCL_FOLD
, cycle
, RUN
, testcycl
Where tc_cycle_id = cy_cycle_id
and cy_folder_id = CF_ITEM_ID
and rcyc_parent_id = rel_id
and rcyc_id = tc_ASSIGN_RCYC
and tc_testcycl_id = rn_testcycl_id
and Tc_cycle_id = rn_cycle_id
and ts_test_id = tc_test_id
and tS_test_id = RUN.RN_TEST_ID
and ts_type not in ( 'QUICKTEST_TEST' , 'SERVICE-TEST')
and year (RUN.RN_EXECUTION_DATE) = 2019
and month (RUN.RN_EXECUTION_DATE) = 9
and day (RUN.RN_EXECUTION_DATE) = 9

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.