Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: avzdk on June 30, 2023, 12:00:39 am

Title: Find relationships not shown in any diagrams
Post by: avzdk on June 30, 2023, 12:00:39 am

During some workshops we may have hidden relationships between uml classes instead of deleting them from the model.
How can I find relationships not shown in any diagrams?

I know that I can find objects with the Diagram Search - Find Orphans, but dont know how to do the same for the relationships.

Can anyone help?

Title: Re: Find relationships not shown in any diagrams
Post by: BobM on June 30, 2023, 12:11:20 am

You can find them in the element properties -> links

Title: Re: Find relationships not shown in any diagrams
Post by: Geert Bellekens on June 30, 2023, 12:46:49 am

You can make an SQL Search,

Start here:

Code: [Select]

select * from t_connector c
where not exists (select * from t_diagramlinks dl
where dl.ConnectorID = c.Connector_ID
and dl.Hidden = 0)
Geert