Author Topic: SQL Search on tag value - how to?  (Read 1649 times)

Ribeye

  • EA User
  • **
  • Posts: 23
  • Karma: +0/-0
    • View Profile
SQL Search on tag value - how to?
« 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.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: SQL Search on tag value - how to?
« Reply #1 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.