8
« Last post by EA Newbie 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!