Get/check all stereotypes via SQL Query?

[Daiim]

Hi all,

using the EA API there is an attribute called StereotypeEx that includes all Stereotypes of a given EA.Element as a comma separated list in a string.
I need to check for a certain Stereotype via SQL Query but the t_object obj.Stereotype only returns the first being set in model. How can I fetch (or better check) the other ones via SQL?

Thank you very much for any hint!

Best regards,
Daiim

[Geert Bellekens]

Hi all,

using the EA API there is an attribute called StereotypeEx that includes all Stereotypes of a given EA.Element as a comma separated list in a string.
I need to check for a certain Stereotype via SQL Query but the t_object obj.Stereotype only returns the first being set in model. How can I fetch (or better check) the other ones via SQL?

Thank you very much for any hint!

Best regards,
Daiim

Full stereotype info is stored in t_xref

Geert

[Daiim]

Geert, thank you! Works great, even if it adds some complexity.

Best regards,
Daniel