JRS/RQM - Reporting with RS on Test Cases when a Test Case Category is undefined
Hello,
|
One answer
Hello Jean-Claude,
SELECT DISTINCT T1.PROJECT_NAME, T1.REFERENCE_ID, T1.NAME AS URL1_title, T1.URL AS URL1, T2.VALUE AS VALUE FROM RIDW.VW_TESTCASE T1 LEFT OUTER JOIN RIDW.VW_TESTCASE_CATEGORY_LOOKUP LT1 ON (T1.TESTCASE_ID = LT1.TESTCASE_ID) LEFT OUTER JOIN RIDW.VW_TEST_CATEGORY T2 ON LT1.TEST_CATEGORY_ID = T2.TEST_CATEGORY_ID AND T2.TERM='Custom1' WHERE T1.PROJECT_ID = 5 AND ( (T2.VALUE='Info not available' OR T2.VALUE='Unassigned' OR T2.VALUE=' ' OR T2.VALUE IS NULL) ) AND (T1.ISSOFTDELETED = 0) AND (T1.TESTCASE_ID <> -1 AND T1.TESTCASE_ID IS NOT NULL) AND (T2.TERM = 'Custom1' OR (SELECT count(*) FROM RIDW.VW_TESTCASE_CATEGORY_LOOKUP LT INNER JOIN RIDW.VW_TEST_CATEGORY T ON T.TEST_CATEGORY_ID = LT.TEST_CATEGORY_ID AND T.TERM = 'Custom1' WHERE LT.TESTCASE_ID = T1.TESTCASE_ID) = 0) Best Regards Francesco Chiossi |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
There's a "Unassigned" selection for custom category in JRS 6.0.3, but not in JRS 6.0.2.