Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: pepices on January 19, 2024, 05:06:37 am

Title: Searching in EA
Post by: pepices on January 19, 2024, 05:06:37 am

Hello all. I'm a newbie with the tool (more ARIS experienced) and now I'm working in searching tasks for identifying duplicate object instances (archimate based, business functions and so on, TOGAF stuff) in EA. Since I need to deal with hundred of repos in my workspace, do you know if any product searching feature allows to you to search only in a selected repository (extended search when you use the tool search in all the repos, and I cannot manage it). If some automated script exists would be great.
Thousand thank you all!

Juan, Spain

Title: Re: Searching in EA
Post by: qwerty on January 20, 2024, 03:28:20 am

The definition of duplicate is somewhat vague. However, you can create a SQL search e.g. with a COUNT clause to find duplicates.

q.

Title: Re: Searching in EA
Post by: EA_enthusiast on January 20, 2024, 04:02:04 am

Juan,
I had a similar question recently. I came across this add-on. I have not tried to use it for this specific problem, but I think it has a feature for funding duplicates.
https://www.eateamworks.com/

Title: Re: Searching in EA
Post by: pepices on January 20, 2024, 04:34:16 am

Thank you so much qwerty, your comments and support are so much appreciated. Maybe I didn't explain clearly. My use case is that I need to use extended search for looking for an artifact named 'Perform_software_development' as an example. When I use the product searching interface, the search is done over ALL repositories in my connection, and I'd like to fix the searching scope to only one of them, is this possible?

Thousand thank, one more time. Best regards,

Juan

Title: Re: Searching in EA
Post by: pepices on January 20, 2024, 04:36:49 am

Thank you so much #EA_enthusiast, I'll give a look on that and let you know.

Best regards,

Juan

Title: Re: Searching in EA
Post by: qwerty on January 20, 2024, 07:56:02 am

Yes, you can limit a search in query using the #branch macro which returns the package ids of the currently selected package.

e.g.

Code: [Select]

SELECT
o.ea_guid AS CLASSGUID, o.Object_type AS CLASSTYPE, o.name, o.Object_type AS Type, o.Stereotype, pkg.name AS [Package Name],
o.modifiedDate AS Modified, o.note AS [Notes]
FROM
  t_object o, t_package pkg
WHERE
pkg.Package_id in (#Branch#)
AND o.name like '#WC#<Search Term>#WC#'

You can add a COUNT clause to limit the result to those which occur multply.

q.

Title: Re: Searching in EA
Post by: DeBAAT on January 22, 2024, 06:00:00 pm

For deduplication, I use the open source IDEA add-on (see https://data-docent.nl/ideaen.aspx (https://data-docent.nl/ideaen.aspx)).