Diagram Usage automated in model search

[Stefan Bolleininger]

Hi!

is it possible to creat an sql search on an query about all elements with type "requirement" in a whole package?

I want to get the output of "Find in all Diagrams" for all elements within a package and its child-packages.

Doesn anyone allready have such a search-query or automation?
It would be great help for me.

Thank you

Stefan

[Geert Bellekens]

yes it is possible.
No I don't have something like that yet

geert

[Stefan Bolleininger]

Do you have any hint for me how to do that?

Thanks

[Geert Bellekens]

You'll need to query
t_object, join it with t_package for the owning package then join t_package a couple of times to get get the subpackages
and then join with t_DiagramObjects and then t_Diagram.

Geert

[Stefan Bolleininger]

SELECT t_object.Object_ID, t_object.Alias, t_object.Note, t_object.Name, t_diagram.Diagram_ID, t_diagram.Name
FROM t_object, t_diagram, t_diagramobjects
WHERE t_object.Object_Type = 'Requirement'
AND t_object.Object_ID = t_diagramobjects.Object_ID

This works somehow, but some Object.Name doesn't work and all Objetct.ID's are here two times.

Is it possible to cut the doubled entry and list all names?

Is it also possible to vie it vice versa and show only those which are not listed in diagrams?

Thanks in advance

[Geert Bellekens]

Yes, all of that is possible.
Sadly enough I don't have time right now to do it for you

Geert

[Eve]

RE: Finding objects not on any diagram. Try the Find Orphans search.

You can also customize this to restrict it to requirements if needed.

[Stefan Bolleininger]

Find Orphans helps mit a bit further but is just half of the way. It is not only needed to know, IF they are all used or not but also WHERE they are used.

Another question: is it possible to generate and print the output of a SQL-Search behind a normal Generated rtf-Report of a Package?
Or do i have to print them out seperated?