Hello everyone I have encountered the code below which looks good but it appears to be double counting for all runs which I do not desire. I need a query that will count the number of requirements and last test run associated with the test run whether it passed, failed, incomplete, and if it failed i’d like to see the number of defects associated against it as either "closed" or "not closed" for defect status. Currently this query will tally and add up all test runs so if you run two test cases in a test set 10 times each time it will count 20 runs for the linked requirement but I only care about the last run so add only the last two runs. I would like to see something like requirement X run 2 times one pass one fail for the fail 5 defects total, 4 closed and one not closed (assuming the last test run had 5 defects against it). This is the query I have:
SELECT DISTINCT(REQ.RQ_REQ_ID) AS "Requirement ID",
Marked as spam
Please log in to participate..