Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Ribeye on March 20, 2023, 03:42:28 am

Title: SQL Search on tag value - how to?
Post by: Ribeye on March 20, 2023, 03:42:28 am

We need to find elements in our model by the value of Tags. Foreign keys to external systems, for example.

This seems like a common requirement and we are new to EA SQL.

Can someone point to or provide a snippet of SQL that will do this?

Thanks in advance.

Title: Re: SQL Search on tag value - how to?
Post by: qwerty on March 20, 2023, 04:47:15 am

Try

Code: [Select]

SELECT * FROM t_objectproperties WHERE object_id = <the element id>
Depending on the mix of MDGs you are using you might need additional info from t_xref, but give the above a try first.

q.