Another question about SQL queries of diagrams

[PeterHeintz]

I want to have my query result clickable so that I can easy move to the diagram.

This works for queries created with the query builder. But what fields I have to alias with CLASSGUID and CLASSTYP when I do pure SQL on t_diagram?

[qwerty]

Start with this one:

Code: [Select]

SELECT t_diagram.ea_guid as CLASSGUID,  t_diagram.Diagram_Type as CLASSTYPE, name from t_diagram

q.

[PeterHeintz]

Hi qwerty,
this I tried already.
 
When I do that, both fields disappear in my query results (what I expected). I also see an icon but a package icon rather than the diagram icon, and when I click on that for roundabout 99% of the rows nothing happen and surprisingly 1% works!?

[PeterHeintz]

In addition:
Right click and „Find in Poject Browser” seem to work for any row!?
EA is really magic!

[qwerty]

I always get the right result. But the icon is never a diagram (EAUI). Never looked in that corner. Need to investigate...

q.

[PeterHeintz]

And even more funny!
Once you have done a “Find in Project Browser” the double click starts to work (row by row!!!) !

[qwerty]

The help http://www.sparxsystems.com/enterprise_architect_user_guide/12.1/building_models/creating_filters.html does not mention diagrams in the result at all. So the case that it works is coincidence and the likely will refuse fixing it (either to forbid it or to return the correct diagram icons). Bug reporters welcome (I'm none).

q.

[PeterHeintz]

This issue is continued here:
http://www.sparxsystems.com/forums/smf/index.php/topic,39168.0.html
So I try to close this one!