Finding Triggers of AcceptEvent (Actions)

[DASHBY88]

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.

[qwerty]

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

q.

[Geert Bellekens]

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

[DASHBY88]

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.