[closed] Counting requirement that links to multiple artifacts
I’m using DOORS next report builder to generate a report. I have three type of requirement. DSM requirement, PS requirement, Drawing list module. Where DSM requirement have links to several PS requirements or/and drawing list modules. The links is in a many to many relationship.
After I generate a report to count the number of DSM requirement have links to PS requirement and drawing list modules. The report showed up the number of DSM requirement that links to PS requirement and drawing list modules respectively.
however I don't know how many DSM requirement have both links to PS requirement and drawing list module
I have tried to set link relationship from optional to required, but it is still not working for counting.
How to resolve it in JRS?
The question has been closed for the following reason: "The question is answered, right answer was accepted" by davidhoney Mar 20 '23, 5:20 a.m.
Accepted answer
Comments
Thanks for your example. If I use your case, image you have very laugh amount of "User Story" ,
In my example:
- For each user story that has a child task, there will be a row for that specific user story that has a non-zero count of the number of child tasks for that specific user story.
-
For each user story that has a parent, there will be a row for that specific user story that has a non-zero count of the parents for that specific user story.
Please start off by defining some example data in a table with 3 rows. The first column should be DSM requirement id. The second column should be the ids of the PS requirements that are linked to from that DSM requirement. The third column should be the ids of the Drawing List Modules linked to from that DSM requirement.Since a requirement cannot be both a PS Requirement and a Drawing List Module, the same id cannot appear in column 2 and column 3 of any single row.
Then, having defined the dataset being queried against, provide an example of the report output you are trying to achieve.