Addin: Read tagged values from Connector element

[Marko Kaiser]

I try to read a specific tagged value from a connector element in a c# addin.

Code: [Select]

EA.ConnectorTag tv = (EA.ConnectorTag)connector.TaggedValues.GetByName("someNiceName");

But at this point EA is throwing an error message box - Action not supported.  I use version 8.0.863 of EA.

Can anybody point me to the right direction?

[qwerty]

I'm afraid GetByName is supported only for very few collections. See the help.

q.

[stao]

for that case i use my own methods

Code: [Select]

public static EA.ConnectorTag findTaggedValue(EA.Connector element, String name)
        {
            element.TaggedValues.Refresh();
            EA.ConnectorTag aTag = null;

            foreach (EA.ConnectorTag aTaggi in element.TaggedValues)
            {
                if (aTaggi.Name == name) aTag = aTaggi;
            }
            return aTag;
        }

or the sql version of the method which will directly returns the value of the taggedValue if there is one with this name.

Code: [Select]

public static String SearchTaggedValueSQL(EA.Repository Repository, EA.Connector actCon, String tagName)
        {
            
            String diagrams = Repository.SQLQuery("select t_connectortag.VALUE FROM t_connectortag where t_connectortag.Property = '"+tagName+"' and t_connectortag.ElementID = "+actCon.ConnectorID);
            MatchCollection diagrams_List = Regex.Matches(diagrams, "<VALUE>.*?</VALUE>");
            List<String> diagram_ids = new List<String>();
            foreach (Match id in diagrams_List)
            {
                String splitted = id.ToString(); ;
                splitted = splitted.Replace("<VALUE>","").Replace("</VALUE>","");
                return splitted;
            }
            return "";
        }

[eaeio]

are there any documentation on the use of SQL queries to get or set properties?

[stao]

unfortunately there are none (afaik)
but what you could do is to use the EA internal SQL Search to check the database and to find out which information you need and how to get it.

In EA open an .eap press STRG+f and switch to SQL tab.

select * from t_object
will get all information of alle elements in the .eap.
strg+space can be used.

[qwerty]

I never asked why GetByName is limited to the current set of collections. Probably the GetByName is not inherited but implemented separately for each collection. Is there any class design for EA? At least it is missing in this region.

q.

[Marko Kaiser]

Thanks four your help. Code works like a charm.