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 11 years, 2 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

eaDocX uses cookies to ensure that we give you the best experience on our website. If you continue we assume that you consent to receive all cookies on the eaDocX website More info

Accept