Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: jack89 on April 28, 2022, 02:10:34 am

Title: [EA query] - How to detect each empty diagram with a query
Post by: jack89 on April 28, 2022, 02:10:34 am

Hi all,

is it possible to retrieve each empty diagram inside the eapx repository with a SQL query inside EA?

Thank you in advance!

Title: Re: [EA query] - How to detect each empty diagram with a query
Post by: Geert Bellekens on April 28, 2022, 03:22:43 am

Sure, simply query all diagrams where there is no diagramObject record

Code: [Select]

select * from t_diagram d
where not exists
(select do.Instance_ID from t_diagramobjects do
where do.Diagram_ID = d.Diagram_ID)
Geert