Custom SQL query

[gnms]

Hi,

I have try to make a custom SQL query, the query work but when I run the query it is not possibly to click on the result and get the object selected in the property view like query make with the query builder.

Please help me to make the object selected in the property view when I click on the object in the search view?

This is the query

SELECT t_object.Name, t_object.Object_Type, t_connector.Name
FROM t_object INNER JOIN t_connector ON t_object.Object_ID = t_connector.Start_Object_ID
WHERE (((t_connector.Name)Like"*<Search Term>*"))

/Mats

[gnms]

I have found the answer
“You can extend the usability of your SQL searches using the aliases CLASSGUID and CLASSTYPE. These enable Enterprise Architect to display the Properties dialog and icon for elements, connectors, attributes or operations, as well as selecting them in the Project Browser. Some simple examples for using these aliased fields are provided below:
SELECT ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE, Name FROM t_object”

/Mats