Find elements with(out) given connection type(s).

[mazy]

Hello.

I have simple question I can't find answer to. Is it possible to find elements (under a given tree node) with or without (more important to me) given connection type in the model?

I know that there are Implementation and Dependency Details, but they can be used only for specific connection types.

Relationship Matrix is nice for some tasks, however I'm looking for something more like the Search View/Find In Project.

Could I use Search View for that somehow?

[thomaskilian]

For existing connections you can use the relationship matrix. For non-existing you might be lucky with an appropriate SQL (nothing I can give an answer out of the blue).

[mazy]

Thanks for your reply. So I can't use the Search View, can I. Too bad - it's quite complex tool, some new fields I could search on would help.

Like "connected element types" and "connector types" - containing list of types.

[thomaskilian]

You might have luck with the Advances search (SQL builder). But you need to go deeper into EA's guts.

[KP]

Is it possible to find elements (under a given tree node) with or without (more important to me) given connection type in the model?

[snip]

Could I use Search View for that somehow?

It should be possible if your knowledge of SQL syntax is better than mine. As Thomas said, there is an SQL builder in the Advanced Search functionality. What you need to do is a select on the t_connector table, finding all records with t_connector.Connector_Type that matches your given type, then do a select on the t_object table where t_object.Object_ID either is or isn't contained in t_connector.Start_Object_ID and t_connector.End_Object_ID. I think a single SQL command will do it.

[mazy]

Amazing, I had no idea that there's such a thing as SQL search. I guess that makes almost anything imaginable possible, thanks a lot.