Recent Posts

Pages: 1 ... 6 7 [8] 9 10
Bugs and Issues / Default connector line style
« Last post by Uffe on June 21, 2018, 05:07:33 pm »
Hi all,

Is there a way to set the default connector line style in a diagram?
Say I want all future connectors to use Tree Style - Vertical, or Orthogonal - Square. Can I set that somewhere?

General Board / Re: SQL query for connections with name="External Reference"
« Last post by Nizam on June 21, 2018, 04:35:16 pm »
Glad it helped. You can refer to from Thomas Kilian
The proposed solution "'Get All Latest' twice, one-time with 'Always Import'" does not work. Most of the times I get "Out of Memory". If it works - for what reason ever - the "External Reference" links still exist.
Now I query all "External Reference" links and "Get Latest" on packages under version control hosting one or the other end of the "External Reference" connection.
General Board / Re: SQL query for connections with name="External Reference"
« Last post by ngong on June 21, 2018, 04:20:27 pm »
wonderful, Nizam - works out of the box. Now I learned e.g. that column Start_Object_ID is foreign key to t_object.

I will try to convince IT to install AnySQL Maestro on the company laptop I am using.

However: where to read further? Not so much SQL, but EA relational schema. Start_Object_ID does not appear in enterprise-architect-object-model.pdf. I am obviosly reading the wrong document. Which of the documents in holds that information?

However, I installed AnySQL on my private computer and it seems that I get all most needed information just from connecting to an .eap file. Thank you Geert.
General Board / Re: SQL query for connections with name="External Reference"
« Last post by Nizam on June 21, 2018, 03:06:05 pm »
Geerts suggestion is best to create useful queries, but Coincidentally i had something similar written for reporting purpose

Code: [Select]
select c.Name as Name, ce.Name as ClientName,  ce.Object_Type as ClientType, se.Name as SupplierName, se.Object_Type as SupplierType   
from (( t_connector c
left join t_object ce on ce.Object_ID = c.End_Object_ID )
left join t_object se on se.Object_ID = c.Start_Object_ID )
where c.Name ='<Name>'
General Board / Re: Mind map connectors
« Last post by KP on June 21, 2018, 02:17:16 pm »
Nothing to do with shape scripts, it's the nature of Bezier connectors. Bezier connectors have three points: the two end points and a control point that determines how far the line bends (visible if you select the connector). If you select and move both the source and target diagram objects at the same time, all three Bezier points will move by the same amount. If you only move one end, the control point won't move, so the line will bend to a different degree and you will probably need to adjust the control point manually.

I'd suggest you get a proper SQL tool to write your queries.
I'm using AnySQL Maestro when writing queries for an .eap model.

Such tools have intellisense and much better error handling than EA.
Only when my query works in that tool I will copy/past it in EA.


PS. EA also has some autocomplete feature  for column names, but that only works when you type in the full table table e.g. "t_connector"
General Board / Re: Mind map connectors
« Last post by Glassboy on June 21, 2018, 01:29:36 pm »
The shape script for the mind map is horrible.
Bugs and Issues / Re: Unable to move Interface on a Port, on a Class
« Last post by Nizam on June 21, 2018, 12:09:16 pm »
Right click on Port -> Advanced -> Port Size Customizable. This will allow Ports to be resized. You'll then be able to move the Exposed interfaces in the Port.

If this is what you are looking for
Bugs and Issues / Re: Project Menu lost
« Last post by Nizam on June 21, 2018, 12:02:54 pm »
I've seen these anomalies to be restored when I apply a different workspace layout. and / or enable all menu sets .
Pages: 1 ... 6 7 [8] 9 10