Having a solution to this is very important. We are in the middle of a job and need to generate a nightly report that adds up the inherited values in the tagged values. The only way to do this right now is very manual. I found one query that gets us close to an answer. It gives the correct answer in EA. DocX seems to run a DISTINCT on the result which strips off the information we need. Here is the query that gives me a list of all of the parts and returns the CLASSGUID for the class that does have all of the correct tagged values:
SELECT aCls.ea_guid AS CLASSGUID, aPart.Name, aPart.Object_Type, aCls.Name
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
WHERE (((aPack.ea_guid)=’‘));
In “Find in Project” in EA I get the following results:
aPart.Name Object_Type aCls.Name
_____________________________________
part1Lt Part class1
part2Lt Part class2
part3Rt Part class2
Notice that the last two entries will return the same CLASSGUID for class2. For some reason, DOCX will not show the tagged values for both of the class2 entries. In DocX I get the following:
ElementType Name TV1 TV2
________________________________
Class class1 25 30
Class class2 80 70
Notice that I only received 1 class 2 result. This means that the duplicate CLASSGUID that DocX receives from the query is deleted from the results. Is it possible to allow the duplicate CLASSGUID to remain in the search result?
