export all transitions from a statemachine

[mati]

Hello,

I modeled a Statemachine with many transitions. With a guard and/or trigger and without a guard or trigger. I also have Substatemachines in my model.

I need an list of all transitions which are included in the Statemachine and in the Substatemachines.

The list could be formatted like the following.

Source	Destination
State1	State2
State3	State1
...	...

it doesn't need to be a table. Also a text list like the following would be enough.

State1_State2
State3_State1
..._...

Since my Statemachine will changed often, I need a way to get the list without too much effort.

Thanks for your help.

Best Regards,

Mati

[Helmut Ortmann]

Hello Mati,

I would write a little query and export the reults to *.csv.

Helmut

[mati]

Hi,
Thanks for your help.

I didn't know that it is possible to do an sql query in the "Model Search".
I tried several thinks. But i wasn't able to get it run like is need it.
SQL didn't help me as well. Is there an documentation for the SQL Tables?

Or what would be the best way to get it done.

Thanks again.

[Geert Bellekens]

Try this when you create a new SQL Search.
(check the manual if you have never added SQL Searches before)

Code: [Select]

select sob.ea_guid as CLASSGUID,sob.object_type as CLASSTYPE, pob.Name as StateMachine, sob.Name as FromName, tob.Name as ToName from (((t_connector c
inner join t_object sob on c.Start_Object_ID = sob.Object_ID)
inner join t_object tob on c.End_Object_ID = tob.Object_ID)
inner join t_object pob on sob.ParentID = pob.Object_ID)
where
pob.Object_Type = 'StateMachine'
and c.Connector_Type = 'StateFlow'
and pob.name like '#WC#<Search Term>#WC#'
order by pob.Object_ID, sob.Name, tob.name
Geert

[mati]

Thanks Geert,

that helps me a lot.
I just added some conditions.

Regards

[mati]

Hi everybody,

I've got one additional question.
How can I add the Trigger, Guards and the effect of a transition in the query?
Shouldn't they a property of the t_connector  ?

Thanks again.

mati

[qwerty]

Check the contents of PDATA2.

q.