Search capabilities: Finding swimlane associations

[Kraemer]

I am using Enterprise Architect version 7.5.850. I have a question about the Search capabilities in order to find assocations of Activity diagram Swimlanes to a Business Worker or Business Actor.  The following details what I’m trying to accomplish.

When I create swimlanes in my activity diagrams, I select an existing business actor or business worker to associate to the swimlane.
The steps that I perform are as follows:
1) Create an Activity Diagram
2) Open the Swimlanes and Matrix... dialog (either right click or select from the Main Window's Diagram menu item)
3) Under Operations select New
4) From the Swimlane Details dialog select the "..." button next to the Classifier
5) From the Select Classifier window I browse to an existing Actor or Worker and select OK for all the open dialog boxes.

Some coworkers have created swimlanes in activity diagrams WITHOUT selecting an existing business worker or business actor. Instead of performing step 4 above, they fill in the Name field of the Swimlane Details dialog and select ok.

In doing this, they thought they were implicitly created the actor/work when really they weren't. The results are swimlanes without Business Actor or Business Worker associations. All they have done is labelled the swimlane.

I would like to be able to perform a search where I am able to find:
All instances of swimlanes in all Activity Diagrams where the swimlane does not have an association to a Business Actor or Business Worker.
OR - if you can think of a way (other than manual) to uncover these non-existent workers and actors.

Please let me know if you require any additional information.
Thanks.

[Geert Bellekens]

Code: [Select]

select d.ea_guid as CLASSGUID,'Diagram' as CLASSType,tx.name as SwimLane, d.name as diagram from t_xref tx
join t_diagram d on tx.client = d.ea_guid
where tx.type = 'swimlane'
and tx.Supplier is null
and tx.name like '*<Search Term>*'
should work

The tx.Supplier refers to t_object.ea_guid. If this is null the swimlane is not connected to an object.

Geert

PS. replace '*' with '%' if you are using an DBMS repository

[AuntJulie]

Hi Geert,

Where do you type that code in?  I have the same issues as well.  I have only about 40 models so I can manually check them if necessary.

[Geert Bellekens]

Julie,

Look here for SQL searches.

Geert

[Kraemer]

Thanks Geert.
Your instructions solved my problem.