TestDirector: Pass / Fail Run Summary Report

pcl2004_27

Description

      This sql code snippet displays all tests cases and sums how many times they have passed and failed


Solution

      1. Log into Site Admin
2. Select the project you would like to report on
3. Select the Bug table
4. Paste the following code in the SQL box
5. Press the Execute SQL button

SELECT t.ts_name, sum(decode(r.rn_status,'Passed',1,0)) as Pass, sum(decode(r.rn_status,'Failed',1,0)) as Fail FROM RUN r, TEST t WHERE t.ts_test_id = r.rn_test_id GROUP BY ts_name