Messages

1

General Board / SQL Queries, Connectors, and 'Find in Diagram'

« on: April 15, 2025, 12:14:46 am »

I am currently running Sparx EA 15.2

I couldn't find an answer elsewhere, but I may not be asking the right questions. My apologies if the answer is obvious and already answered elsewhere.

I have a SQL Query that lists objects as an output in a model view. One of the features of this list is in edit view I can right click and select 'Find in Diagram' and it will pull up the diagrams the object is located in. I can find where an object is used in multiple diagrams and use this to search for potential overlap, redundancy, or opportunity for collaboration.

I have a SQL Query that lists connectors. The connectors are information flows (X document for review, X request for more information, etc.). The idea for listing these connections in a model view is to also search for potential overlap, redundancies, collaboration opportunities. If two different parts of my organization are talking to the same external agency, I would like to be able to locate it and potentially consolidate it. When I put the model view in 'edit view', and I right click on a connector, the option for 'Find in Diagram' is grayed out. One work around I was given was 'Display in Search View' and this worked, somewhat at first. Initially, in search view I could right click, 'Find in Diagram' and navigate to where a connector was from the search list. I'm not sure why, but the feature has stopped working. Maybe I changed something about the SQL Query when trying to get it to 'Find in Diagram' from the model view.

I would provide the SQL Queries I'm using, but I'm unsure what I can share out of my database in my current role. Does anyone know how to write a SQL Query that would accomplish what I'm asking Sparx to do? Or is it not a possibility because of how the database is set up?

Thank you for your time and your help!

2

General Board / Re: "Find in all diagrams" not showing for information flows

« on: June 28, 2024, 11:39:01 pm »

Find in all diagrams only works for elements, not connectors. In order to find them you need to write a (tricky) query or write a script. Maybe someone here has something in his drawer?

q.

Thank you for your reply!

3

General Board / "Find in all diagrams" not showing for information flows

« on: June 27, 2024, 11:53:42 pm »

I'm using Sparx EA 15.2. I recently created a diagram with multiple operational exchanges as information flows. They appear in the diagram and in the browser, but when I right click them in the browser and choose "find in all diagrams" the resulting table shows as blank, even though I can plainly see they're on the diagram. Am I adding the connectors on the diagram incorrectly? I want to utilize the "find in all diagrams" feature to easily locate which diagrams contain the same connector so we can show who all receives said information. As a general example: An information flow "Pizza Completed" would show a pizza is finished being made, and both the customer and the manager is notified, but their processes would be on two diagrams. Thank you for any help you can provide.