Sparx Systems Forum
Enterprise Architect => General Board => Topic started by: Modesto Vega on January 09, 2024, 11:44:49 pm
-
Have I imagined this? I seem to recall that in previous version of Sparx EA it was possible to use a SQL query to specify the source or target elements on a relationship matrix. But on version 16.1.1628 (64-bit) I cannot find a way of doing this.
Somehow, I need to restrict the target of a matrix from 1,000s of elements to just 2 or 3 dozen elements in scope, and create relationships to a limited list of source elements. Is there another way of doing this?
-
You could collect the elements of interest in a separate package and then select the contents of that package as source or target.
-
Have I imagined this? I seem to recall that in previous version of Sparx EA it was possible to use a SQL query to specify the source or target elements on a relationship matrix. But on version 16.1.1628 (64-bit) I cannot find a way of doing this.
Next to the Source and Target there are buttons called "Set": click those and select "Apply Model Search". You will need to have saved your SQL query as a model search beforehand.
-
Thank you KP, found the same answer earlier this week but didn’t have time to update the thread.
One important usability point, the query needs to be saved under My Searches, and, in the window opened by the “Set” button, My Searches doesn’t exactly jump, it really needs to be at the top or bottom, not buried in between text with a tiny font.