Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: DASHBY88 on November 10, 2023, 02:59:16 am

Title: Finding Triggers of AcceptEvent (Actions)
Post by: DASHBY88 on November 10, 2023, 02:59:16 am

I've searched through the tables in the SQL but can't find how Triggers and AcceptEvent objects are linked. For all other types of Actions it's the Classifier field but not for AcceptEvents. Any help is much appreciated.

Title: Re: Finding Triggers of AcceptEvent (Actions)
Post by: qwerty on November 10, 2023, 11:37:15 am

A shot in the dark: t_xref.behavior can have Trigger andEvent as content.

q.

Title: Re: Finding Triggers of AcceptEvent (Actions)
Post by: Geert Bellekens on November 10, 2023, 06:58:36 pm

Quote from: qwerty on November 10, 2023, 11:37:15 am

A shot in the dark: t_xref.behavior can have Trigger andEvent as content.

q.

Correct:

Code: [Select]

select o.Name as ActionName, tr.Name as TriggerName
from t_object o
inner join t_xref x on x.Client = o.ea_guid
and x.Behavior = 'trigger'
inner join t_object tr on tr.ea_guid = x.Description
where o.ea_guid = '<guid of the Action>'
Geert

Title: Re: Finding Triggers of AcceptEvent (Actions)
Post by: DASHBY88 on November 10, 2023, 09:03:34 pm

Thanks both had to look at a simple model using your guidance.  Had to do some lovely string manipulation because we wanted the Specification of the Trigger returned but got there in the end.