how to read test case exe history from test lab ?
I want to read the execution count of particular test case from test set from test lab..
test lab-->test set--> tc1,tc2,tc3,tc4.
in the above structure i want to read each test case execution history..there is a case we may execute one test case to many times due to many reason...i just want to access the test case hisoty and list out the nos for pass,fail,na if any....
cany anyone help me to reach tat part..
thanks in advance.
Re: how to read test case exe history from test lab ?
Hi Velu, this SQL could help you. You may want to uncomment some lines:
select cy_cycle_id, cy_cycle, ts_test_id, ts_name, tc_status as last_status,
count(case when rn_status='Passed' then 1 end) as Passed,
count(case when rn_status='Failed' then 1 end) as Failed,
count(case when rn_status='N/A' then 1 end) as N_A,
count(rn_status) as Executed
from cycle join testcycl on tc_cycle_id = cy_cycle_id
join test on ts_test_id=tc_test_id
left join run on rn_cycle_id=cy_cycle_id and rn_test_id=tc_test_id
-- and rn_execution_date between '1/1/2000' and '1/1/2020'
-- where tc_cycle_id in (select cy_cycle_id from cycle where cy_cycle='My Test Set Name')
group by cy_cycle_id, cy_cycle, ts_test_id, ts_name, tc_status
order by cy_cycle, cy_cycle_id, ts_name, ts_test_id