Sparx Systems Forum
Enterprise Architect => General Board => Topic started by: Paulus on March 30, 2022, 06:39:37 am
-
Hi All,
I wonder if/how it is possible to create a document template that can handle the following:
I have a number of activities defined, lets call them activity1, activity2, etc.
In a diagram describing a certain scenario i include actions that are callbehaviors of for those activities. So for instance actionA and actionB are callbehaviors of activity1, actionC is callbehavior of activity2
I can create in a document a table that for each step displays name and notes, but what i would like to do is include information on the activity that is refrenced as well. So for each step:
- the name of the step
- notes of the step
- the name of the referenced activity
- some notes for that activity
So in the example what i would like is a table with content:
| actionA | notes for actionA | activity1 | notes on activity1 |
| actionB | notes for actionB | activity1 | notes on activity1 |
| actionC | notes for actionC | activity2 | notes on activity2 |
The 1st two columns is easy but what about the last tow? Is this even possible in EA?
best regards,
Paul
-
Definitely possible, but you'll want to use an SQL fragment to do this.
Geert
-
Thx Geert, i'll look into those!
-
Here's the query for a template I did a while ago:
select isNull(o.Name, act.name) as ActionName, o.Note as [Description-Formatted] , act.Name as ActivityName
from t_object o
left join t_object act on act.Object_ID = o.Classifier
inner join t_diagramobjects do on do.Object_ID = o.Object_ID
inner join t_diagram d on d.Diagram_ID = do.Diagram_ID
and d.ParentID = o.ParentID
where o.Object_Type = 'Action'
and o.parentID = #OBJECTID#
order by do.RectTop DESC, do.RectLeft
Geert
-
Thx! That will help a lot :)