SQL driven matrix profile

[Modesto Vega]

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?

[ea0522]

You could collect the elements of interest in a separate package and then select the contents of that package as source or target.

[KP]

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.

[Modesto Vega]

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.