Products

Home Forums eaDocX queries Excel tagged values Excel tagged values

Home Forums eaDocX queries Excel tagged values Excel tagged values

#7104
David
Participant

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)=’‘) AND (
(t_objectproperties.Property=’Power’) OR
(t_objectproperties.Property=’Weight’) OR
(t_objectproperties.Property=’Cost’))

Will return the tagged value property and result(value). The Excel filter will not let me do this. It expects an

  • This reply was modified 10 years, 5 months ago by David.

Compare licence prices

Choose the licence that’s right for you and your team

Prices

Download a free trial

Download eaTeamWorks today for several free for life features, plus no obligation, 30-day trials of all the products: eaDocX, ea Revision Manager, eaSheets, Model Expert and PortfolioManager. Discover for yourself why we sell the world’s best-selling Enterprise Architect extension.

Download