How To
Summary
How to find IBM Engineering Requirements Management - DOORS Next (DOORS Next) artifacts that are not in any module using Report Builder for IBM Jazz Reporting Service (JRS).
Objective
It is possible in DOORS Next to have artifacts that do not belong to any Module or collection, so you need a way to report on these.
DOORS Next has the concept Reusing artifacts in modules that can lead to duplicate artifacts appearing in JRS reports. Using Filtering out unwanted duplicate DNG artifacts in Report Builder results you can remove the duplicates from a report.
Steps
To find artifacts which are not included in any module or collection using Report Builder and the Lifecycle Query Engine (LQE) data source.
- Build a simple report that uses the LQE or LQE with configurations data source.
- Data source: Lifecycle Query Engine
Artifact types: Requirement
Artifact relationships:
<Requirement> → Used By (Optional) → <Requirement Collection>
Columns:
Requirement Id
Requirement
Id
[Type: Requirement Collection]: Count total number of artifacts by ID
You must add an attribute to count the number of Requirement Collection artifacts byID
.
You also must remove the Requirement URL as it affects the grouping. Unfortunately you lose the link to the specific artifact in the report results.
You could Limit the scope of the report to a specific project area if required.
- Data source: Lifecycle Query Engine
- You need to edit the SPARQL of the report.
Open 'Format Results'>Advanced and 'Edit Query'
- Modify the '
GROUP BY
' statement:
From:GROUP BY ?oslc_rm_Requirement1_identifier ?oslc_rm_Requirement1_title
To:GROUP BY ?oslc_rm_Requirement1_identifier ?oslc_rm_Requirement1_title HAVING(?oslc_rm_RequirementCollection1_identifier_COUNT=0)
NOTE: Once you edit the SPARQL, you will NOT be able to modify the report using the graphical user interface (GUI). Therefore, get the report details correct before you edit the SPARQL.
Document Location
Worldwide
[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTU9C","label":"Jazz Reporting Service"},"ARM Category":[{"code":"a8m0z000000CbLvAAK","label":"Jazz Reporting Service->Report Builder"}],"ARM Case Number":"TS004215133","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
Was this topic helpful?
Document Information
Modified date:
15 December 2020
UID
ibm16336839