Query for "Find in All Diagrams"

[Gokcen Guner]

Hello,
I need to implement the functionality provided in GUI by CTRL-U. Is there a way to do this?

[qwerty]

You can write a SQL to accomplish that. It's probably just a couple of Joins you need. Sorry, I can't give a ready to use solution here.

q.

[Gokcen Guner]

OK I will try to write it and share here.
Thank you.

[Gokcen Guner]

This works:

select * from t_diagramobjects dobj1, t_diagramobjects dobj2 where dobj1.object_id=dobj2.object_id and dobj1.diagram_id!=dobj2.diagram_id;

Thanks.