Tests Not Passed per Execution Plan report only shows the tests that were executed in the last run

[Valerie]

In an execution plan, I have 2 runs, but when I create the report "Tests Not Passed per Execution Plan", I have only the result of the last run.

Is it possible to combine the results of all the runs contained in an execution plan in 1 report.

Thanks

[Hubert Inreiter]

Hi Valerie,

This would mean including every ever failed test per execution plan in the report?

In the screenshot it looks like this would be in context of automated tests. For example, if the execution plan run 5 times and test 'A' failed in each of these runs, then there should be 5 rows in the report for this test?

I think the data you are looking for can be found in the DataMart tables and views (DM* and RV*). There the test run results can be queried in context of execution plans:

SELECT ExecutionPlanID ExecDefId, ExecutionPlanName ExecDefName, TestID TestDefId, TestName TestDefName,      

 PassedCount, FailedCount, NotExecutedCount, TestRunID TestDefRunId, ProjectID ProjectId

FROM RV_TestStatusExtended tse

INNER JOIN TM_ExecTreePaths etp on tse.ExecutionPlanID = etp.NodeID_pk_fk

WHERE ProjectID = ${$PROJECTID} AND etp.ParentNodeID_pk_fk = ${execNode_Id_0|1|ExecNodeID}

AND tse.StatusID = 2

Regards,

Hubert