Number of elements contained in a requirement diag

[paleantrop]

Hi all,

I have different requirements diagrams containing quite a lot of elements. Is there a way to have a statistic about how many elements are in each diagram?

Thank you in advance!

[qwerty]

You can achieve that with a SQL search (using COUNT), a script or by showing the diagram as list and copy/paste to Excel.

q.

[paleantrop]

Thanks for your fast reply. I appreciated.

The first think I did was to switch to "List View" and copy to Excel. This step has to be done for each diagram.
I will have a look at SQL search to check if I can find a way to count the number for all at once.

[paleantrop]

Could you, please, give a small example searching using SQL in a requirements diagram?

Thank you in advance.

[qwerty]

For example

Code: [Select]

select count(*) from t_object, t_diagramobjects, t_diagram where t_diagramobjects.Object_ID = t_object.Object_ID and t_diagram.Diagram_ID = t_diagramobjects.Diagram_ID and t_diagram.Name = "Package2"
returns the number of elements shown on the diagram(s) named "Package2". Of course you would use the diagram guid to get the right diagram. And you would limit the elements (t_object) by type and/or stereotype.

I'd recommend to use a little script to construct/process the query. Use Repository.SQLQuery ("SELECT ...")

q.

[paleantrop]

Thanks! it worked.

Now I noticed that I have same diagram name in different packages. So, I   tried to count the req. from a specific package. The structure looks like this:

--Package1
----Sub-package1
------ReqDiagram

--Package2
----Sub-package2
------ReqDiagram

I added a "t_package" and tried to join, but it doesn't work:

Code: [Select]

select count(*) from t_object, t_diagramobjects, t_diagram, t_package where t_diagramobjects.Object_ID = t_object.Object_ID and t_diagram.Diagram_ID = t_diagramobjects.Diagram_ID and t_package.Package_ID= t_diagram.Package_ID and t_diagram.Name = 'ReqDiagram' and t_object.Object_Type='Requirement' and t_package.Name='Package2'

Any suggestion will be welcomed.

[qwerty]

Better use the diagram guid. You can retrieve that via context menu: Copy References/...GUID... and use that via t_diagramobject.ea_guid

q.

[paleantrop]

Thanks again. It works. I think it is the best solution.

[qwerty]

You might want to look into scripting later. This would e.g. allow to run the query for the currently open diagram.

q.

[paleantrop]

Yes, this is want I would like to learn next. For my current tasks I need to developed some scripts in order to get statistics for different packages/diagrams.