I need to generate couple of reports from QC and for that I need SQL Queries
1. Find list of Test Cases which are failed /Blocked with defects which are now closed or deferred or rejected.
2. Find list of defects which are not linked to any test case
3. find list of Test Cases which are failed or blocked but not linked to any defect.
I am finding difficulty in getting the correct tables to write the SQL query.
All I could find is the solution to point #2
“defect”.”BG_BUG_ID” AS “Defect ID”,
“defect”.”BG_DETECTED_BY” AS “Raised By”,
“defect”.”BG_PROJECT” AS “APPLICATION”
--BG_USER_01, BG_USER_08, BG_USER_02, BG_CYCLE_ID, BG_DETECTED_IN_RCYC, BG_DETECTED_IN_REL
“defect”.”BG_BUG_ID” NOT IN (Select DISTINCT LN_BUG_ID from LINK)
and this works well.
But I am not able to get a go for 1 and 3