Why does JRS report for a simple trace shows me non linked records?
We are running CLM 6.0.1. i am creating a QM report in JRS using Test plan > Test Case > Test Execution Record > Test Case Result.
The result shows me TCERs for Test cases which do not have Test Plan(unassigned). Why is this happening? I thought that the trace ability relationship will make sure to select TCER which belong to that Test Plan only.
The TCER with ID 14275 has no Test Plan associated with it. This should be shown under Unassigned test plan and not under Test Plan A where the same "Test case 1" is used. Is this working as designed?
|
2 answers
Hello Anup,
SELECT DISTINCT T1.PROJECT_NAME, T1.REFERENCE_ID, T1.NAME AS URL1_title, T1.URL AS URL1, T2.REFERENCE_ID AS REFERENCE_ID1, T2.NAME AS URL2_title, T2.URL AS URL2, T3.REFERENCE_ID AS REFERENCE_ID2, T3.NAME AS URL3_title, T3.URL AS URL3, T4.REFERENCE_ID AS REFERENCE_ID3, T4.NAME AS URL4_title, T4.URL AS URL4 FROM RIDW.VW_TESTPLAN T1 INNER JOIN RIDW.VW_TESTPLAN_TESTCASE_LOOKUP LT1 ON (T1.TESTPLAN_ID = LT1.TESTPLAN_ID) INNER JOIN RIDW.VW_TESTCASE T2 ON (T2.TESTCASE_ID = LT1.TESTCASE_ID) INNER JOIN RIDW.VW_EXECUTION_WORKITEM T3 ON (T2.TESTCASE_ID = T3.TESTCASE_ID) INNER JOIN RIDW.VW_EXECRES_EXECWKITEM_LOOKUP LT2 ON (T3.EXECWORKITEM_ID = LT2.EXECWORKITEM_ID) INNER JOIN RIDW.VW_EXECUTION_RESULT T4 ON (T4.EXECUTION_RESULT_ID = LT2.EXECUTION_RESULT_ID) WHERE (T1.ISSOFTDELETED = 0 AND T2.ISSOFTDELETED = 0 AND T3.ISSOFTDELETED = 0 AND T4.ISSOFTDELETED = 0) AND (T1.TESTPLAN_ID <> -1 AND T1.TESTPLAN_ID IS NOT NULL) AND (T2.TESTCASE_ID <> -1 AND T2.TESTCASE_ID IS NOT NULL) AND (T3.EXECWORKITEM_ID <> -1 AND T3.EXECWORKITEM_ID IS NOT NULL) AND (T4.EXECUTION_RESULT_ID <> -1 AND T4.EXECUTION_RESULT_ID IS NOT NULL) AND (T1.TESTPLAN_ID = T3.TESTPLAN_ID) The above is the query generated by a simple report using the traceability you described. The added condition to force the TCER to match the Tesplan is the last line. 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.