SqlQuery'ing t_taggedvalue

[blawton]

I'm trying to get a taggedvalue from a couple thousand requirements, which becomes cumbersome pretty quickly when I have to build the elements and parse through EA.Collection structures. I'm trying to use SQLQuery to get directly to the tagged values with something like:

Code: [Select]

"SELECT TagValue FROM t_taggedvalue WHERE ElementID  = <<requirement_element_id>>;"
 Suffice to say this doesn't work. Even when I do a general query like

Code: [Select]

"SELECT * FROM t_taggedvalue;"  I only get a few hundred results. Given that there are a few thousand requirements which all have 10+ taggedvalues associated with them this can't be right, so what am I doing wrong? When I rebuild the tags like so:

Code: [Select]

EA.Element currReq = (EA.Element)Repository.GetElementByID(objID);
EA.Collection tags = (currReq.TaggedValues);
EA.TaggedValue tag = (EA.TaggedValue)tags.GetByName("Status");
I get all the information I need, so I know the information is stored in a taggedValue, I must just be doing something wrong. Any tips for doing this by query?

[stao]

try this to get all taggedValues in the repository:
"select * FROM t_objectproperties" for EA.Elements and
"select * FROM t_connectortag" for EA.Connectors

[Geert Bellekens]

To complete that:
- t_attributetag for the attributes tagged values
- t_operationtag for the operations tagged values

t_taggedvalue seems to contain "the rest" of the tagged values. The elementID needs to be interpreted depending on the BaseClass.
If it's ASSOCIATION_SOURCE or ASSOCIATION_TARGET then you need to join t_connector on t_connector.ea_guid = t_taggedvalue.ElementID
if its PACKAGE you need to join t_package on ea_guid.

Geert

[blawton]

Thanks, that did the trick!

I assume all this is gleaned from the database structure and painful experience, or is there some hidden documentation I haven't found yet?

[Geert Bellekens]

blawton,

You haven't missed anything, there just isn't any documentation about the EA database.

Geert
(and YES it's painful )