Why does JRS report for a simple trace shows me non linked records?

Hello Anup,

the traceability link is enforced only between the 2 elements directly connected by the link.
If you want to enforce a condition between Test Plan and TCER you need to explicitly add it.

Best Regards
Francesco Chiossi

Hello Anup,

it looks like you cannot add the condition through the UI, so it has to be done on the SQL code itself.

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