I have created the following SQL query:
SELECT part_e.ea_guid as CLASSGUID, part_e.Object_Type as CLASSTYPE, port_s.Name as s_port, part_s.Name as s_part, blk_s.Name as s_blk, port_e.Name as e_port, part_e.Name as e_part, blk_e.Name as e_blk
FROM (((((t_object AS port_s INNER JOIN t_connector AS c ON port_s.Object_ID = c.End_Object_ID) INNER JOIN t_object AS port_e ON c.Start_Object_ID = port_e.Object_ID) INNER JOIN t_object AS part_e ON port_e.ParentID = part_e.Object_ID) INNER JOIN t_object AS part_s ON port_s.ParentID = part_s.Object_ID) INNER JOIN t_object AS blk_s ON part_s.PDATA1 = blk_s.ea_guid) INNER JOIN t_object AS blk_e ON part_e.PDATA1 = blk_e.ea_guid
This query works great in EA. I can also use it to find items in diagrams and in the project browser.
I do the following:
1) Create a new excel workbook in my EA model
2) Click on the searches tab. Select my query from the list.
I get the following error:
SQL failed:
System.runtime.interop.services.COMException (#): To run a custom search you must specify ea_guid AS CASSGUID …
As you can see in my query, I have it specified. Any ideas what is wrong?
.
