Run report with configuration name and step details

  • Questions
  • Run report with configuration name and step details
Question ID: 105730
0
0

Hi All,

Does anybody have a sql query to generate Test id >> Run id >> Expected result>> step description >> configuration name report from ALM 11

Please suggest I am trying the below report but its pulling the configuration name from Test plan I want it from Test lab

SELECT CYCLE.CY_CYCLE as Test_Set ,
TEST.TS_NAME as Test_Case,
rn_run_id as ‘run id’ ,
"test_configs"."TSC_NAME" AS " Configuration Name",
–st_description as Step_Description ,
–st_expected as Step_expectedresult ,
TESTCYCL.tc_actual_tester as Tester,
testcycl.tc_plan_scheduling_date as ‘Planned Esec Date’,
STEP.ST_STATUS as Step_Status ,
RN_EXECUTION_DATE as rn_exe_date,
rn_execution_time as execution_time , ,
RUN.RN_TEST_CONFIG_ID AS "Configuration ID"
FROM CYCLE, TESTCYCL, TEST, STEP, RUN ,cycl_fold ,test_configs
where CYCLE.CY_CYCLE_ID = TESTCYCL.TC_CYCLE_ID
and cf_item_path like ‘A%’
AND (TEST.TS_TEST_ID = TESTCYCL.TC_TEST_ID)
and(test_configs.TSC_TEST_ID = TESTCYCL.TC_TEST_ID)
AND (RUN.RN_TESTCYCL_ID = TESTCYCL.TC_TESTCYCL_ID)
AND (STEP.ST_RUN_ID = RUN.RN_RUN_ID)
AND TESTCYCL.TC_TESTCYCL_ID = RUN.RN_TESTCYCL_ID
and tc_cycle_id = cy_cycle_id
and cf_item_id = cy_folder_id
ORDER BY CYCLE.CY_CYCLE, TESTCYCL.TC_TEST_ID

Marked as spam
Posted by (Questions: 10, Answers: 5)
Asked on November 20, 2014 4:56 pm
7 views
Answers (1)
0
Private answer

I figured it out

Marked as spam
Posted by (Questions: 10, Answers: 5)
Answered on November 20, 2014 11:02 pm
can you provide more details on the answer?
( at November 21, 2014 12:43 pm)