Hello all,
Can someone help please, I have a strange issue. We use CLM v6.0.1 and I am trying to generate a report in report builder. Data Source is Rational Data Warehouse and Database Vendor is DB2
The traceability link I have used is
Release --> Feature --> Test Case
where Release work item is an RTC work item that has 10 Features linked to it (Feature is also an RTC work item) and the 10 Features have 188 Test Case linked up to them (As we all know test cases are in RQM).
Now, when I run the Report Builder (JRS), it is displaying 208 test cases instead of 188 test cases. When I manually checked the results line by line, I found that a few test cases are repeating in the results and hence it is 208.
I then realized that SELECT DISTINCT will do the trick. But, when I went into Advanced query section, SELECT DISTINCT was already there, but still the repeated entries are coming up in the results.
However, when I remove all the columns from the queries and kept only one column (T3.NAME), which is test case column, it is displaying correct results which is 188 test cases. But, if I add 2 or more columns in the SELECT DISTINCT, it won't show the correct results.
Below is the first 2 lines of the query which will show 208 test cases
SELECT DISTINCT T3.NAME,T2.NAME AS NAME1
FROM RIDW.VW_REQUEST T1
If I remove T2.NAME AS NAME1 from first line, then I get correct results
SELECT DISTINCT T3.NAME
FROM RIDW.VW_REQUEST T1
I need bot the Features and Test Cases column in the result screen but I only need DISTINCT rows to be displayed. Please can you advise.
Thanks
Venkatesh Prasad