Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: atallec on May 16, 2013, 07:18:19 pm

Title: SQL query :: Returns author for each connector
Post by: atallec on May 16, 2013, 07:18:19 pm

Hi,

I am looking for an SQL query that returns two colums:
1] the author name, 2] the connector name

The t_object table has an author column whereas the t_connector doesn't.

Any idea ? Thanks !

Alexandre Tallec

Title: Re: SQL query :: Returns author for each connector
Post by: Geert Bellekens on May 16, 2013, 07:36:19 pm

You can't since EA doesn't store the author for connectors.
(Auditing might, I'm not sure)

You could of course return the author for the source of the connector, counting on the fact that it is probable that the other of the source object also is the one that created the connector. :-/

Geert

Title: Re: SQL query :: Returns author for each connector
Post by: qwerty on May 16, 2013, 08:24:37 pm

The author is (likely) stored in one of the bincontent columns of t_snapshot - but in zipped format. For a SQL not really available.

q.

Title: Re: SQL query :: Returns author for each connector
Post by: Rodrigo Nunes on May 17, 2013, 12:37:39 am

see if it helps with this query. :)

select top  10 t_object.Author, t_object.Object_ID, t_connector.Name from t_object
inner join t_connector
on t_object.Object_ID = t_connector.End_Object_ID

Title: Re: SQL query :: Returns author for each connector
Post by: qwerty on May 17, 2013, 06:31:04 am

That's like Geert suggested the creator of one of the connected elements, but not of the connector itself.

q.