Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

[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? 


https://imgur.com/a/lnJotai

image 

0 votes


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

Permanent link
It works for me. Here's is an example using work items:

In that example, I want to count the number child tasks (Task) of a user story, and the number of parents (Parent Work Item). In the format tab, I selected a count by URL for Task, and again for Parent Work Item:


Here is an excerpt of the results:


This shows that 521004 has 2 child tasks and no parents, and that 521042 has 1 child task and 1 parent work item.


kaman kwok selected this answer as the correct answer

0 votes

Comments

Thanks for your example. If I use your case, image you have very laugh amount of "User Story" , 


How to show the counting number of User Story. that have link to both task and parent. 

The table should be something like here below: 

| Link Target      | number of User story| 
|Task                 | 6
|Parent              | 7
|Task & Parent  | 2

I do not understand your example output.

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.
If a specific work item has 6 tasks and 7 parents, these will be disjoint. In other words, a work item counted in the Number of tasks column will not be counted in the Number of Parents column. A given work item contributes to the count in either the Number of tasks column or the Number of Parents column, but never both.

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.


One other answer

Permanent link

From your referenced screenshot, it looks like you are counting the number of DSM Requirements. Instead, try adding a column to count the number of PS Requirements, and a separate column that counts the number of Drawing List Modules.

0 votes

Comments

   I have tried your suggestion before, however, it only show "How many PS Requirements have link to DSM Requirement" and ""How many Drawing List Modules have link to DSM Requirement"

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,014

Question asked: Mar 07 '23, 10:51 p.m.

Question was seen: 967 times

Last updated: Mar 20 '23, 5:20 a.m.

Confirmation Cancel Confirm