Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - Ravaa

Pages: [1]
Hi all

Still a Sparx EA newbie so this may be really simple, but is it possible to create a user-defined set of filters to visually filter out classes / relationships in a class diagram?

e.g. user creates 3 filters
  • Show all HR related classes and relationships
  • Show all Finance related classes and relationships
  • Show all Recruitment related classes and relationships
User can select from these, and the wider 'organisation class diagram' filters / greys out those classes / relationships which aren't relevant to these filters

Thanks in advance

Hi folks

I'm currently attempting to obtain a search that provides me the following information:

- Class
- Class description
- Attribute (so 'Class' would repeat for multiple attributes per class)
- Attribute tagged values (so 'Attribute' and 'Class' would repeat for multiple tagged values per attribute)

I've had a look at Geert's 'favourite SQL queries', and figured the SQL query below is probably the closest I can get to the above - however my SQL knowledge is almost non-existent so not sure how to expand to include the above. Can someone please assist?

Code: [Select]
select a.ea_guid as CLASSGUID,'Attribute' as CLASSTYPE, as Name, a.Type as 'Type', as 'Class Name'
, as 'Package Name' , as 'Package level -1', as 'Package level -2', 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.Name like '#WC#<Search Term>#WC#'

Pages: [1]