14
« on: September 23, 2022, 08:08:34 pm »
the problem is that you have twice the column Name in your query.
Give the package name a different alias, and you should be fine
select t_package.Name as PackageName, ...
Also, it's a good idea to use proper join syntax to keep your sanity.
Something like this:
select act.ea_guid AS CLASSGUID, act.Object_Type AS CLASSTYPE,
p.Name as PackageName, actor.Name as ActorName, act.Name as ActionName, d.Name as DiagramName, act.ea_guid
from t_object prt
left join t_object actor on actor.Object_ID = prt.Classifier
and actor.object_type = 'Actor'
inner join t_object act on act.ParentID = prt.Object_ID
and act.object_type = 'Action'
inner join t_package p on p.Package_ID = act.Package_ID
left join t_diagramobjects do on do.Object_ID = act.Object_ID
left join t_diagram d on d.Diagram_ID = do.Diagram_ID
where prt.object_type = 'ActivityPartition'
and p.Package_ID in (#Branch#)
PS. If you want this to work on a .eap file you'll need to add a bunch of parentheses to cater for weird the MS-Access syntax.
Geert
Show Posts
