One work around is to let me run a SQL statement from Excel without filtering the data I get back. With a SQL I can ask for the Tagged values of the classifiers. The problem I have is if I have multiple parts pointing to the same class, the CLASSGUID filters out the duplicates (the two parts that point to the same value).

For example, the SQL

SELECT t_objectproperties.ea_guid AS CLASSGUID, aPart.Name, aPart.Object_Type, aCls.Name, t_objectproperties.Property, t_objectproperties.Value
FROM (t_object AS aCls INNER JOIN (t_package AS aPack INNER JOIN t_object AS aPart ON aPack.Package_ID = aPart.Package_ID) ON aCls.ea_guid = aPart.PDATA1) INNER JOIN t_objectproperties ON aCls.Object_ID = t_objectproperties.Object_ID
WHERE ((aPack.ea_guid)=’

• This reply was modified 11 years, 2 months ago by David.