[EA query] - How to detect each empty diagram with a query

[jack89]

Hi all,

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

Thank you in advance!

[Geert Bellekens]

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