Matrix with model search

[Hurra]

Hi!

I have some problems creating a matrix with a model search.

It works with some searches, not at all with others.

Simple search which DOESN't work:

Code: [Select]

select objekt.ea_guid as CLASSGUID, objekt.Object_Type as CLASSTYPE, objekt.Name as objektName, objekt.Object_ID as oID

from t_object objekt
inner join t_object parent on objekt.ParentID = parent.Object_ID

where parent.ea_guid = '<Search Term>'

Search which DO work:

Code: [Select]

SELECT interface.ea_guid AS CLASSGUID, interface.Object_Type AS CLASSTYPE, interface.Name AS Name

FROM t_object  interface
INNER JOIN t_object port ON port.PDATA1 = interface.ea_guid
INNER JOIN t_object s ON s.Object_ID = port.parentID

WHERE port.Object_Type = 'Port'
AND s.ea_guid = '<Search Term>'

Does someone know why some searches work and some do not?

Thanks!

[qwerty]

objekt.ParentID


q.

[Hurra]

objekt.ParentID


q.

?

The searches works in the 'Find in Project' tab.

[qwerty]

Ah, forget it. I got confused with your German writing of Object.

q.

[Geert Bellekens]

"AS" vs "as"

For some reason EA sometimes cares about the capitalization of the AS keyword.

Geert

[Hurra]

Ah, forget it. I got confused with your German writing of Object.

q.

It's swedish

[Hurra]

"AS" vs "as"

For some reason EA sometimes cares about the capitalization of the AS keyword.

Geert

wow...

Thank you 

Now that I see the elements I realized I have another problem.

All the connectors are through ports. Therefore my matrix is empty because I do not have connectors from element to element, only port to port. Can I solve this somehow? Or do I just have to give up the idea of a matrix? 

[Geert Bellekens]

Technically ports are elements too, but I don't know if you can use them as such in the relationship matrix.

If not then I would contact sparx support.

Geert

[qwerty]

It's swedish

Let's agree on Northern Europe Post Brexit.

q.

[qwerty]

Regarding the ports/interfaces you will need to use indirect access. That is something like "where parent is port and parent-parent is element". I'm no SQL nerd, so you have to do the coding on your own, but it's probably feasible.

q.