Search attributes by type

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

select a.ea_guid as CLASSGUID,'Attribute' as CLASSTYPE,a.name as Name, a.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_attribute  a
inner join t_object class on a.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 a.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)

This article contains content available for registered members only. You need to be logged in to view/download this content.