How to get the most recent verdict of Test Case with Report Builder?
-
Traces from a specific Market Release object to all Test Cases that are linked in any way whatsoever to that Market Release
-
Returns the most recent Test Result for each Test Case, or the last verdict for the Test Case -- once.
One answer
I used the Report Builder customization options documented here https://jazz.net/wiki/bin/view/Main/ReportBuilderNewSchemaDiscovery to provide an easy workaround for my users, since the 'Current Result' data is already available in the data warehouse.
@prefix db: <> .
@prefix ridw: <http://jazz.net/ns/reporting/dwse#> .
@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix d2rq: <http://www.wiwiss.fu-berlin.de/suhl/bizer/D2RQ/0.1#> .
@prefix jdbc: <http://d2rq.org/terms/jdbc/> .
@prefix jrs: <http://jazz.net/jrs/reportbuilder/datawarehouse#> .
@prefix sg: <http://jazz.net/ns/reporting/sparqlgateway#> .
# Add in a custom link type to Current Execution Results
map:RIDW_VW_EXECUTION_WORKITEM_CURRENT_RESULT a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:RIDW_VW_EXECUTION_WORKITEM;
d2rq:property ridw:RIDW_VW_EXECUTION_WORKITEM_CURRENT_RESULT_ID;
d2rq:refersToClassMap map:RIDW_VW_EXECUTION_RESULT;
d2rq:join "RIDW.VW_EXECUTION_WORKITEM.CURRENT_RESULT_ID => RIDW.VW_EXECUTION_RESULT.EXECUTION_RESULT_ID";
d2rq:propertyDefinitionLabel "Current Result";
.
Once you refresh the metamodel, you'll have a new 'Current Result' link type option when building a traceability report.
