Enterprise Architect version 15.2



My Profile

Social Media Channels

facebook  twitter  youtube   linkedin

Thursday, 26 November 2009 09:22

Search operations by parameter type

Written by
Rate this item
(0 votes)

Paste the following sql code into the sql editor, or import the attached xml file

select o.ea_guid as CLASSGUID,'Operation' as CLASSTYPE,o.name as Name,p.Type as 'Type',  class.name as 'Class Name'
,package.name as 'Package Name',package_p1.name as 'Package level -1',package_p2.name as 'Package level -2',package_p3.name as 'Package level -3'
from ((((((t_operation  o
inner join t_operationparams  p on o.operationID = p.operationID)
inner join t_object  class on o.object_id = class.object_id)
inner join t_package  package on class.package_id = package.package_id)
left join t_package  package_p1 on package_p1.package_id = package.parent_id)
left join t_package  package_p2 on package_p2.package_id = package_p1.parent_id)
left join t_package  package_p3 on package_p3.package_id = package_p2.parent_id)
where p.type like '<Search Term>'

To use this search use SQL wildcards as defined by the repository you are working on.

Standard SQL = "%" and "_"

MS Access (eap file) = "*" and "?"

If you don't like to use wildcards in the search box you can change the '<Search Term>' into '%<Search Term>%' (DBMS) '*<Search Term>*' (MS Access eap)

Read 5323 times Last modified on Tuesday, 09 April 2013 04:39
Geert Bellekens

Geert Bellekens

Bellekens IT (Consultant)

Bellekens IT was founded in 2004 by Geert Bellekens and has a strong focus on UML, modelling and analysis methodology.

Geert Bellekens has helped several of the larger Belgian organizations to define and document their modelling method, train and coach the modelers and develop supporting tools.

Geert Bellekens is an acknowledged Enterprise Architect expert and has written numerous add-ins for Enterprise Architect, including the free open source EA Navigator and EA-Matic.

He is also one of the founding members and a regular speaker on the EA User Group events.

Login to post comments